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
Click to expand...
 
Top