Faking Section Headers for Months of Year

[kristin9280]

I'd like a report that displays a section header and footer for every month
of the year, even if no records have data in that month. The report is not a
crosstab and it really can't be in this scenario. Is there any way to fake a
section header for each month? Ideally it would be like this...
January
$0
Subtotal for January: $0
etc.

 

[tina]

i think so, yes. create a table of months. add that table to the query used
by the report, with a left join from the months table to the month field in
the data table. if you don't have a month field in the data table,
well...SQL isn't my strong suit, so i'll take the easy way out and say
instead of the above, create a month field in the original query, as
MyMonth: Month(DateFieldName)
then create a second query, based on the months table and the original
(modified) query, with a left join from the months table to MyMonth. if the
second query's recordset shows you all the months, even where there is no
data in the data-table fields, then that's what you'll have in the report as
well.

hth