Sort date lists into month

  • Thread starter Thread starter Nyanko via AccessMonster.com
  • Start date Start date
N

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.
 
One way would be to add a new column and group on it. In the new column
put...

SortMonth: Month([YourDateFieldName])



Rick B
 
Back
Top