Always including Month Year

[puforee]

I run a query to feed a spreadsheet. The query sums several columns and groups by month/year. The problem....sometimes there is nothing to sum for a month (no records) but I want to include ALL months in the output. Of course the months with no activity (records) would show zero in all columns.

Right now the query skips the months that have not records in the table. How can I set it up so it will still show all months.

Thanks,

 

[SkipVought]

hi,

You need another table containing ALL the dates you want, and do an outer join to include all dates from the dae table.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}