Need a report that displays totals for week and month

[TrunksSenkawa]

I have a call log database that stores among other things, the date and the department the call was for. I need to create 2 reports that total the number of calls to each department for a set week and set month. I want to be able to add weeks and months as time goes by, of course. How would I go about doing this? Would Excel work better?

 

[Pat Hartman]

If you mean that you want to specify a week or month each time you run a report, you can use a parameter in your query.

 

[TrunksSenkawa]

What query? How do I get it to count the # of instances of a certain department name for a set date interval? Sorry, I'm a novice .