| Subject | Date Asked |
|
| Question about query | 11/15/2009 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 ...
|
