Number of entries totalled by month.

[Linty Fresh]

I swear I used to know how to do this, but I've tried a few things and can't figure it out.

OK. I've got a table with a date function. When you enter a file, it automatically puts in the date of entry. What I want to do is total the number of entries by month. I'd like the finished query to read something like:

Month # entries
January 113
February 37
March 90

and so on. Right now, I've got a query with EntryMonth:Month([Date]) and TotalMe: [EntryMonth] and then "sum" selected under "Group By," but this isn't doing it. What am I missing?

 

[pbaldy]

For starters, if you have data in for more than one year that will combine all the January's, etc. Try

EntryMonth:Format([Date], "yyyymm")

I'd probably also use count. Try this:

SELECT Format([Date], "yyyymm") As EntryMonth, Count(*) As TotalMe
FROM TableName
GROUP BY Format([Date], "yyyymm")