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?