count query access 2003

[Weresmytriple]

hi im currently trying to count the amount of records that fall in each month in the date complete field.

i am currently using a count query and it it bringing up the dates not the month

thanks for any help


michael

 

[Brianwarnock]

Use month(your datefield)

Or

Format(your datefield, "mmm")

Brian