access thread: Got the day, need week and month.
Message #1 by "Samuel Gan" <tsutomusenkawa@h...> on Mon, 21 Oct 2002 08:30:55
|
|
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
Message #2 by "Ralph Jones" <kilquonk@y...> on Mon, 21 Oct 2002 17:29:36
|
|
I think it's just a matter of changing day(...) or date(...) in SQL to week(...) or month(...). Could
actually be @week(...) or @month(...).
> I have a query that sums the number of instances of a field [Department]
f> or every day. I need to create 2 queries; one creates the sums for a
week
a> nd one for a month.
T> he left column is the departments and the top row is the weeks.
S> o in the week, it would display along the row as:
1> 0/20/02 10/27/02 11/03/02
> In the month:
1> 0/02 11/02 12/02
|
View Cart
