By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,604 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Access Query Delivery Using Time Blocks

P: n/a
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.

Aug 3 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

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?

Aug 3 '06 #2

P: n/a
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?
Aug 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.