Date/Time field and Calculation Question

K

Kennedys21

I have a Date/Time field (ex. 11/1/2008 12:00:11 AM), a User ID field, and a
Carton Number field.

I am having trouble building a query that will count all the carton numbers
for the user in a day. I'm not sure how I would get the calculation to only
look at the date, and disregard the time.

The end result is to see how much an individual did each day over the span
of a month.

Any help would be appreciated.
 
J

Jeff Boyce

Check out the DateValue() function. Add it to a query, convert the query to
a totals query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

Kennedys21

This worked like a charm. Thanks!

Jeff Boyce said:
Check out the DateValue() function. Add it to a query, convert the query to
a totals query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top