Grouping by month

[DLSE]

In a query, I have entered
"Month: Month([NameofDateField])". This works to group a count by month instead of individual days. However, the query does not list months that have no corresponding data. How do I make the query include every month of the year, even if some do not have data (the count would be "0" for these months).
Thank you,
Matt

 

[r937]

see

Selecting all months even if they're missing

http://tinyurl.com/9u0n

the integers table comes to the rescue again!!


rudy

http://r937.com/