Date/Time field and Calculation Question

  • Thread starter Thread starter Kennedys21
  • Start date Start date
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.
 
Check out the DateValue() function. Add it to a query, convert the query to
a totals query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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...
 
Back
Top