| Subject | Date Asked | Expert |
|
| Question about query | 11/15/2009 | Iain M Watson |
Q: I have the following query: SELECT * FROM PickListDetails WHERE Quantity=(SELECT MAX(Quantity) from ...
A: Your problem is that you need a GROUP BY statement at the end of the SQL statement for the columns ...
|
| conceptual database design | 10/4/2009 | Iain M Watson |
Q: I have a question on a homework problem asking me to Identify the mandatory/optional dependencies ...
A: this look like a relational databases question ?? If so then we are talking about existence ...
|
| SQL Query | 9/23/2009 | Iain M Watson |
Q: In a view I want to count the number of activities (CMTR_WR_ActivityType) per person ...
A: I am not sure which database you are using, but most SQL is the same in relational databases. You ...
|
| Which program to use | 9/11/2009 | Iain M Watson |
Q: I have built an Access database that I want to re-write in a different program for resell as web ...
A: If you want to use the database thru a webserver/browser yuo should probably use MySQL and apache ...
|
| access 2003 inventory database | 8/19/2009 | Iain M Watson |
Q: My question is that I need to create and inventory database that can be added to and subtracted from ...
A: I am not completely clear on what you need. But a basic Inventory database has an Inventory table ...
|
| Dbms | 7/17/2009 | Iain M Watson |
Q: what is the basic difference between DBMS & RDBMS?
A: RDBMS is "Relational database management system", DBMS is the same minus the relational. There are ...
|
| calculations in databases | 7/13/2009 | Iain M Watson |
Q: how do i create an expression that affects two fields in two different tables in a form
A: You can use the POST_TRIGGER command. You can have a block level POST_INSERT trigger on one table ...
|
| Database and caller id | 7/10/2009 | Iain M Watson |
Q: My friends parents run a small cleaning company. They have some database that was written by someone ...
A: This is not an area of my expertise, but there are a few companies that I have found on the ...
|
| database | 7/9/2009 | Marty Landman |
Q: can i find work in database in Brazil or USA. what is the scope of database in Brazil and USA. ...
A: Saeed, Freelance work which is what I do is getting harder to find right now, because of the ...
|
| DB Form | 6/12/2009 | Marty Landman |
Q: We need to tick several boxes from a choice of 10 in a form. So a combo/option/checkbox/list box is ...
A: Maggie, It sounds to me like a checkbox would be perfect for your user interface. Look at the ...
|
| Password | 6/4/2009 | Marty Landman |
Q: I'm probally in the wrong place and if I am please tell me where to go. How can I change my ...
A: Shawn, If you're running windows you'd boot up in safe mode, by pressing F8 while the machine is ...
|
| Database pools? | 5/12/2009 | Carlson Lim |
Q: Does there exist a database application that will pool together similar files of your choice? For ...
A: Amazon and iTunes have similar functionality. Users can group songs or discs to their liking. If ...
|
| Database of emails | 3/24/2009 | Marty Landman |
Q: I work on projects where I need to email a particular message to between 100 to 400 web site ...
A: Sort of. You could use a web scraper function which would probably have to be custom built to do a ...
|
| Choosing a database program | 2/23/2009 | Marty Landman |
Q: I have used a simple database years ago and I am no whizz or statistician. However now, I find ...
A: Chris, First, I don't know SPSS. I do know that it is a canned statistics program, probably ...
|
| Excel duplicate finder | 1/2/2009 | Carlson Lim |
Q: I want free software for checking duplicate words in Excel (Deduplication check Software). I have ...
A: You can use the Control F function to see all of the matches by clicking Control F, then Options, ...
|
| Table, query, and relationship design with membership and attendance | 10/12/2008 | Carlson Lim |
Q: I'm trying to design a database for an organization that will record membership in groups and track ...
A: It looks like you have a good start on your project. I see that you have tables set up for members ...
|
| DBase | 7/29/2008 | Carlson Lim |
Q: do you know anything about dbase or Dos? We have old system and don't know how back-up discs would ...
A: Joe, It depends on what version of dbase you're using. A long long time ago I used dbase III, but ...
|
| POS Database | 7/14/2008 | Marty Landman |
Q: I'm trying to make a POS point-of-sale software. I only know using ms access for database. Is ms ...
A: Jeric, Access is a fine database - your most important decision might be which platform to use ...
|
| 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 ...
|
