Group by Month

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
 
S

Steve Schapel

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")
 
Top