date functions

[Judy]

I'm trying to count the number of rows in a column for
each month of the year--it's a date/time data type, and I
tried the 'DATEPART' SQL function but Access doesn't seem
to recognize that.

How do you do a criteria to convert 7/1/03 to just 7,
then count the rows? Or is there a simpler way to get all
the rows each each month counted?

thanks!

 

[John Vinson]

How do you do a criteria to convert 7/1/03 to just 7,
then count the rows?

Put a calculated field in the query by typing

MonthNum: Month([datefield])

in a vacant Field cell; make it a Totals query and group by this
field.