how do I tally number of calls on a given date?

[Guest_imported]

Working in a help desk I'm setting up an Access database to log all of my calls. I'd like to be able to print out reports for my boss. Such as, the number of calls on a given date. I'm using the autonumber format in my forms to number each call but I'd like to be able to print reports for a specific day, week, month, or year.

I would like to be able to see a total, not just the call numbers for that day.

Any ideas?

bobZemuda

 

[Databaseguy]

You're going to have to store a date somewhere. then, create a query, and use the GroupBy Function on the date field (It's the one with the Sigma Symbol), with another field set to an expression that looks like this
Expr1: Count(*)
Only include the date field and the expression, as the group by Groups By unique combinations of fields. For example, if you included date and call Id then 7/31/01 Call ID 1 and 7/31/01 Call ID 2 are two records with a count of one each. Whereas removing the call ID would have one record, 7/31/01, with a count of two.