date functions

  • Thread starter Thread starter Judy
  • Start date Start date
J

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!
 
How do you do a criteria to convert 7/1/03 to just 7,
then count the rows?
Click to expand...

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.
 
Back
Top