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

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