How can I group data per month or week in a query

[Eichel]

Hello!

I have following question:
using SQL or any other way in Ms Access95 is it possible to group or order data from a table, weekly or monthly? And sum for each group (using another table or a query).
for example:
the table used is sorted descending like that:

02/01/2000 1
11/01/2000 0
13/01/2000 0
13/01/2000 1
14/01/2000 1
20/01/2000 0
29/01/2000 1
.
.
.

I hope this won't get too complicated, but I would appreciate any help anyone has to offer.
thank you indeed,

Axel

 

[tlbroadbent]

Select Month(DateCol) As Mnth, sum(DataCol) As Tot
From table Group By month(DateCol)

If you have multiple years on the table you can use something like the next query.

Select format(DateCol, "yyyy/mm&quot As Mnth, sum(DataCol) As Tot
From table Group By format(DateCol, "yyyy/mm&quot Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.