Breaking out totals

  • Thread starter Thread starter jpw
  • Start date Start date
J

jpw

I have a table with a field for "date workorder received"
(type date). I would like to break these down by month
and get totals. I can do this one month at a time with a
query. How can I get all twelve totals without writing 12
different queries?

Thanks,
John
 
Hi jpw,

Use the Month() function. For ex:

SELECT Sum([Orders]) AS Total, Month([DateReceived]) AS Months
FROM YourTable
GROUP BY Month([DateReceived]);

hth,

LeAnne
 
Back
Top