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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Year to Date subquery 3
Repost, Help with combining queries 2
Help combining Queries 2
Monthly Totals 8
Reduce # of date columns in crosstab query 4
Group by month 2
grouping quarters 3
SQL Group and Sum Question 3

Back
Top