report grouped by month is skipping months

[arage]

report grouped by month is skipping months
My report is grouped by month but is skipping some months altogether, as they do not appear in my tables as data. I’m interested then in providing some sort of code (I’m assuming) behind my groups that will determine if a month is missing & then print out a line of null /zero values.

I was thinking along the lines of using a do/while loops or something, am I on the right track?

 

[Abby N]

What I've done in situations like this is create a table containing one field. That field lists each of the items I wish to include in my report, in this case each month. For the purpose of this discussion I'll refer to that table as tblMonths and your source table as tblData. Include tblMonths in your source query and join it to tblData, defining the join to include all records from tblMonths and only those records from tblData where the joined fields are equal. This won't actually limit your recordset, as all months will exist in tblMonths. But, it will ensure there is at least one record for each month is returned. If I didn't explain this very well let me know and I'll send you a sample database. Hope this helps.

~Abby


[This message has been edited by Abby N (edited 08-22-2001).]