Access Query Delivery Using Time Blocks

[audiophilechris]

Can anyway help me write this query? I've created a DB to help me
manage delivery logistics for items I rent out. I have a table that i
use to record delivery date, delivery time, pickup date, pickup time,
and quantity (of items to drop off). All of the items are identical so
i don't need to distinguish by type. I have 80 deliveries and 80
pickups over 7 days. I would like to generate a query that will list
the total number of items out each day. I do not need to account for
the specific times throught the day.

[pietlinden]

au*************@gmail.com wrote:

Can anyway help me write this query? I've created a DB to help me
manage delivery logistics for items I rent out. I have a table that i
use to record delivery date, delivery time, pickup date, pickup time,
and quantity (of items to drop off). All of the items are identical so
i don't need to distinguish by type. I have 80 deliveries and 80
pickups over 7 days. I would like to generate a query that will list
the total number of items out each day. I do not need to account for
the specific times throught the day.

You already posted this - verbatim. We heard you the first time. Do
you mean the items delivered? Or delivered but not picked up? Or? What
_exactly_ do you mean by "out"? (Business rule? "Out" = all the items
that have not been picked up?)

Just wondering why you have delivery date and delivery time in separate
fields...

Sounds like you could just use a totals query.

(Apologies to Albert Kallal for this...)

"Loan"

<---------------------timeline-------------<NOW>------------------------>
o---------------------o
o------------------------o

o-----------------------------------o
IssueDateStamp<NOW AND
(returnDateStamp>NOW or returnDateStamp IS NULL)

right?

[audiophilechris]

Sorry about posting twice. This is really the first time I've used
google groups and I wasn't sure if my first post was in the correct
category. I believe the expression you wrote below is on the right
track. However, what I would like to do is project inventory for the
whole week these deliveries are taking place. In other words, I do not
want to query the inventory that is out currently, but analyze what it
will daily while this event takes place (in the future). Thanks again
for your post!

pi********@hotmail.com wrote:

au*************@gmail.com wrote:

Can anyway help me write this query? I've created a DB to help me
manage delivery logistics for items I rent out. I have a table that i
use to record delivery date, delivery time, pickup date, pickup time,
and quantity (of items to drop off). All of the items are identical so
i don't need to distinguish by type. I have 80 deliveries and 80
pickups over 7 days. I would like to generate a query that will list
the total number of items out each day. I do not need to account for
the specific times throught the day.

You already posted this - verbatim. We heard you the first time. Do
you mean the items delivered? Or delivered but not picked up? Or? What
_exactly_ do you mean by "out"? (Business rule? "Out" = all the items
that have not been picked up?)

Just wondering why you have delivery date and delivery time in separate
fields...

Sounds like you could just use a totals query.

(Apologies to Albert Kallal for this...)

"Loan"

<---------------------timeline-------------<NOW>------------------------>
o---------------------o
o------------------------o

o-----------------------------------o
IssueDateStamp<NOW AND
(returnDateStamp>NOW or returnDateStamp IS NULL)

right?