If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a select query from multiple fields on the same table
Hi all,
I've created a table for stores, the primary key is Store Name. I've created another table for input of deliveries to stores on an employee's shift. This is set up as Load 1,2 and 3 with Drop 1,2,3 and 4 in each load. Each drop is validated from the store name field in the store table. Each drop has an arrival and departure time. The relationship set up between the store and deliveries table is a one to many from store name in the stores table to the Load 1, drop 1 field in the deliveries table. The query i want to create is by store, summarising duration for each drop. I've set up a select query and added a calcuated field for each drop. However the query output is blank. Any pointers on what I'm doing wrong? Thanks, Steven |
#2
|
|||
|
|||
Creating a select query from multiple fields on the same table
Post your query so we can help with it. You can copy your query by
selecting the SQL View and then paste it into your next post. -- Daryl S "WhiteTiger" wrote: Hi all, I've created a table for stores, the primary key is Store Name. I've created another table for input of deliveries to stores on an employee's shift. This is set up as Load 1,2 and 3 with Drop 1,2,3 and 4 in each load. Each drop is validated from the store name field in the store table. Each drop has an arrival and departure time. The relationship set up between the store and deliveries table is a one to many from store name in the stores table to the Load 1, drop 1 field in the deliveries table. The query i want to create is by store, summarising duration for each drop. I've set up a select query and added a calcuated field for each drop. However the query output is blank. Any pointers on what I'm doing wrong? Thanks, Steven |
Thread Tools | |
Display Modes | |
|
|