how do I

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

Hello.

I need help. I have a table in Access that has only two
columns - usernumber and date. I need to write a report so
that I can count total for each user per day. I've look in
my access book and online help, but didn't get very far.
Not sure if I have to use VBA to do this or some other
method. Any help would be appreciated.

Thanks
 
joe said:
Hello.

I need help. I have a table in Access that has only two
columns - usernumber and date. I need to write a report so
that I can count total for each user per day. I've look in
my access book and online help, but didn't get very far.
Not sure if I have to use VBA to do this or some other
method. Any help would be appreciated.
Click to expand...

Create a new query. In the query design grid add your table and bring both
fields down. In the main menu turn on View - Totals. Leave the date field
as GroupBy but change the [usernumber] setting to Count.

If your date field does NOT include time, then your done. Just base a
report on this query. If it does then change the field for the date field
to DateValue([yourfieldname]). That will strip the time component off of
the date.
 
Back
Top