Sort date lists into month

[Nyanko via AccessMonster.com]

I have a file with rows of data by date e.g. 01/06/05,05/06/05,08/06/05 how
can I create a query that groups totals by month not by indiviual date.

I hope this makes sense.

 

[Rick B]

One way would be to add a new column and group on it. In the new column
put...

SortMonth: Month([YourDateFieldName])



Rick B