I have a query that sums the number of instances of a field [Department] for every day. I need to create 2 queries; one creates the sums for a week and one for a month.
The left column is the departments and the top row is the weeks.
So in the week, it would display along the row as:
10/20/02...