TrunksSenkawa
Registered User.
- Local time
- Today, 18:55
- Joined
- Oct 10, 2002
- Messages
- 13
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 10/27/02 11/03/02
In the month:
10/02 11/02 12/02
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 10/27/02 11/03/02
In the month:
10/02 11/02 12/02
Last edited: