Group by Month

  • Thread starter Thread starter kirstie adam
  • Start date Start date
K

kirstie adam

I have a date field which i want to group by month in a query, how do i do
this?
Field is [OrderDate]

Thanks,

Kirstie
 
Kirstie,

Assuming your data spans more than one year, and you don't want the
December 2006 data combined with the December 2005 data... In design
view of the query, make a calculated field by typing this into the Field
row of a blank column in the query design grid:
GroupMonth: Format([OrderDate],"yyyymm")
 
Back
Top