| Subject | Date Asked | Expert |
|
| Combining two records from a query into one record | 6/26/2008 | Carlson Lim |
Q: e. the table has colour information say 30 different colours each with a pattern size. I then get ...
A: This is possible if you create a query that will query Expr3 in your example above. The SQL would ...
|
| Calculating a business day | 4/18/2008 | Marty Landman |
Q: Do you know a simple method of taking a date and calculting 5 business days from that date? For ...
A: Jill, You didn't say which database you're using. Mysql, like the other databases has extensive ...
|
| Skip Blank Line | 4/14/2008 | Marty Landman |
Q: .expert, I have a report, i would like to skip blank line records, how?
A: Hasmukh, It depends. What are you doing specifically? What software are you using? Can you check ...
|
| simple database | 4/11/2008 | Marty Landman |
Q: not sure if I've found the right expert, but, I'm looking for a simple database program that will ...
A: Johnny, Have you looked at Excel? This sounds like exactly what spreadsheets are designed for. Also ...
|
| Auto select items in a list box based on a combo box | 4/9/2008 | Marty Landman |
Q: . i have a small form based on a query, i have one list box of all names in the list and one unbound ...
A: Yankel, Selecting on the fly is only possible using: 1) javascript 2) Ajax 3) server side ...
|
| ms access | 2/29/2008 | Marty Landman |
Q: I have a database from which I need to export data (a query)! The data needs to be exported in a ...
A: Neil, I'm not familiar with MS Access' export options, however maybe this shareware product will be ...
|
| Oracle global variable | 2/18/2008 | Marty Landman |
Q: I having an oracle 3 tier design, i have a hp-ux based oracle database, and windows 2003 base oracle ...
A: Ali, While I don't personally have experience with this issue I found a discussion involving what ...
|
| Suggest Database Software | 2/13/2008 | Marty Landman |
Q: I have been looking around at some different database software, but have not committed to anything. ...
A: Pat, It doesn't matter which database you use, just as it doesn't matter whether you use Snap On or ...
|
| Query optimization | 2/12/2008 | Marty Landman |
Q: Wanna know some of the key points by which we can optimize a big query with so many joins,running ...
A: Deepa, Start with these online tutorials http://littlelink.webtrouble.com/?WMQP ...
|
| access to web | 2/11/2008 | Marty Landman |
Q: I have a filter tracking database on access standalone. we put in air monitoring field data. Lab in ...
A: Bob, With all due respect you will either need to get a bid from a programmer like me or have ...
|
| access to web | 2/11/2008 | Marty Landman |
Q: I have a filter tracking database on access standalone. we put in air monitoring field data. Lab in ...
A: Bob, If by easy you mean is this something a person with no web development experience can do in a ...
|
| FUNDAMENTALS OF DATABASE | 8/16/2007 | Ivan Maskovic |
Q: Sir, i want to know the definitions of a key,primary key,secondary key & the difference among these. ...
A: Regarding keys, I found this helpful article on wikipedia ...
|
| data security | 8/7/2007 | Marty Landman |
Q: I want to know about ; how we can secure our data base file, so that anybody can't open it. Can we ...
A: There are two basic things you can do which I am familiar with. First, have an id and password set ...
|
| Maintaining a database on the web | 8/2/2007 | Marty Landman |
Q: What programs are available (and what is the best) for a db that needs to be web accessible?
A: There really are a wide variety of options here. From the very simplistic such as my form to ...
|
| Mail Labels | 7/14/2007 | Marty Landman |
Q: I have a database completed of 850 names, addresses. I wish to merge this info to mailing labels. ...
A: I would approach this by writing a simple program to print the data out, and then use the newline ...
|
| Inventory Database | 7/3/2007 | Marty Landman |
Q: Hey Marty, I have Microsoft Access 2003 and I need to create a database that will store all of the ...
A: Jay, This involves the development of an application. What I mean is that you can input the ...
|
| Query Help needed | 6/19/2007 | Ivan Maskovic |
Q: I need help in writing a query which works in the following scenario: I have two tables Contacts ...
A: Sorry Jon, I haven't any experience with Oracle SQL dialect. Nevertheless I would try this: select ...
|
| Building a Database | 6/18/2007 | Marty Landman |
Q: I am planning to manage a website that stores client data (information) through forms, and also ...
A: Avneesh, You may be in luck. I have an open source product which takes form data and puts it on ...
|
| Query Help needed | 6/8/2007 | Ivan Maskovic |
Q: I need help in writing a query which works in the following scenario: I have two tables Contacts ...
A: select a.*, b.contactid from Contacts as a inner join Country_Contacts as b on a.contactid = ...
|
| SQL | 5/30/2007 | Marty Landman |
Q: I am studying IT and have an exam and I know I should know this but I have only just found out there ...
A: Look at http://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html and you'll see 12.2.1. ...
|
| sql - create table | 5/25/2007 | Ivan Maskovic |
Q: I'am currently using terradata and sql to access our dataware house, I'am new to both. I'm ...
A: First I should tell I have no experience with terradata. But if I understand your issue right, a ...
|
| ms access | 5/5/2007 | Carlson Lim |
Q: I have an access database and I'm stuck with how to rank records. What i did was place a rank field ...
A: Let's say the table for this is named Task, with columns TaskID, TaskName and RankNumber. I'm not ...
|
| database programming | 3/16/2007 | Marty Landman |
Q: I am using a vb data project. the database is ms access database. the problem arises when I try to ...
A: What changed to make this a problem? Or is it possible that the data in certain rows was not right ...
|
| Access | 3/14/2007 | Marty Landman |
Q: Goodafternoon. Could I ask you one question concerning MS Access? I have one table A table with ...
A: Can you please write back with the table descriptions for the two tables? Also with an example of ...
|
| Too much data for access database | 2/17/2007 | Marty Landman |
Q: Good morning. I have been requested to create training db. Been given list of employee names, list ...
A: Lori, I would split this into multiple tables and find relationships between them through ...
|
| SQL date query question | 2/15/2007 | Marty Landman |
Q: How would I then get a list like this?: TOTAL_PRICE_PER_MONTH MONTH 100 ...
A: Not knowing how the table is organized can suggest the easiest way would be to collect the ...
|
| SQL date query question | 2/15/2007 | Marty Landman |
Q: I have a database which has a list of products, then a list of the price of each product, and then a ...
A: TJ, select sum(price) from _________ where transactionDate like '__/02/____'; assuming the date is ...
|
| powerpoint slides in MS Access database | 10/10/2006 | Marty Landman |
Q: Marty, this is difficult to describe. I guess I need a table with slides, but do I need to convert ...
A: Suggest you consider using Open Office http://www.openoffice.org/ to convert your .ppt files into ...
|
| powerpoint slides in MS Access database | 10/10/2006 | Marty Landman |
Q: I have a project where I have about 200 Powerpoint slides and need to put them in a database so that ...
A: Phil, Sorry about the false 'can't answer' reply. My mouse has a mind of its own sometimes. Not ...
|
| transferring excel spread sheet into a searchable database | 10/4/2006 | Marty Landman |
Q: I am cutting and pasting information from "yell.com" on potential advertisers for my company into an ...
A: Michele, The answer to the questions is a resounding "maybe". It's possible to export data from ...
|
| HR Template Database Design | 10/2/2006 | Marty Landman |
Q: I'm looking for a Human Resource Database Schema. I've been looking on the internet, but cannot find ...
A: Louw, Here are several including an Oracle DB demo - as you can see XML is the popular methodology ...
|
| BTRIEVE LOCK FILES | 9/26/2006 | Marty Landman |
Q: Good research. Thanks for the tips. I have tried everthing, including DOS emulator modes. I may ...
A: Ted, I'm surprised you're being left high and dry like this, especially given the info I saw about ...
|
| BTRIEVE LOCK FILES | 9/26/2006 | Marty Landman |
Q: Do you have BTRIEVE data engine tuning experience? I have a ten year old DOS based accounting ...
A: Ted, Although I am not expert at Btrieve I can tell you that a quick search showed this ...
|
| How to write procedure? | 9/13/2006 | Marty Landman |
Q: I need a script for the below raised question or can you give the concept for the below question.I ...
A: This sounds like a merge application. It's a common problem in computer programming. Suggest begin ...
|
| Condor on XP | 8/5/2006 | John L. Anderson |
Q: I have used Condor exclusively in various business and personal applications for well over 10 years. ...
A: Ah, it is such a treat to hear words such as yours. It was as though I myself thought of them. ...
|
| condor dbms | 7/15/2006 | John L. Anderson |
Q: I have been using condor for at least 25 years. Is there a windows program that does works the same ...
A: Ron. Yes, I have asked these questions many times. And the only answer I have found, is that ...
|
| Dos to Windows conversion of database program | 6/9/2006 | John L. Anderson |
Q: The fear that we have is that the proprietary program we are running will bomb one day and the ...
A: Frank: This puts a different light on the situation. Yes, you should switch to a Windows-based ...
|
| Dos to Windows conversion of database program | 6/8/2006 | John L. Anderson |
Q: We are a private golf club in a retirement community in Sun Lakes AZ. We have approx 500 members and ...
A: You have hit on a sore spot with me. I am a DOS man, primarily because it will never produce an ...
|
| Condor 3 under Win98 | 3/2/2006 | John L. Anderson |
Q: I have been running Condor 3 database on a computer under MS-DOS in Windows 3.1. When I run the ...
A: Carl. You are right. I use Condor within 98, and it runs really good--no problems at all. So I am ...
|
| Condor in Windows 2000/XP | 1/19/2006 | John L. Anderson |
Q: I have one of the original Condor Database Programmers working for us, she refuses to use Access, ...
A: Condor will not work with XP. So if you want to continue with Condor, stick with Win 98. (With ...
|
