Totals Query

[Jim W]

I'm trying to build a simple Totals query. I have a Date entered value I have a number field. I would like to be able to total the Number field by Month. How do I do this?

Jim

 

[jfgambit]

SELECT Month([Date]) AS [Month], Sum(tblInfo.Items) AS SumOfItems
FROM tblInfo
GROUP BY Month([Date]);

HTH