Group a report by month and include months with no data

[David Robinson]

I am creating a year-end report (not a crosstab) that will group summarized
data by month. It works fine for months where records exist but I would like
the report to include all months, displaying "no activity" or something
similar for months without data. I suppose I could just enter a garbage
record for each month into the underlying table but that seems like giving up.

Any suggestions?

Thanks in advance.

 

[Duane Hookom]

You could create a table with a date for every month and then use a LEFT or
RIGHT JOIN to display all months.

 

[David Robinson]

I'm not familiar with LEFT or RIGHT JOIN but I think I understand your
meaning. I added a "Months" table to the query and added its "Month" field
with "is null or is not null" in the criteria and it seems to have solved the
problem. Thanks!