how do I

[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

 

[Rick Brandt]

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.

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.