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). I am fairly new to access, so is there a somewhat simple way to do this?
Thank you,
Matt
"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). I am fairly new to access, so is there a somewhat simple way to do this?
Thank you,
Matt