Report: Create for 12 months when some months data unavailable

  • Thread starter Thread starter DMUM via AccessMonster.com
  • Start date Start date
D

DMUM via AccessMonster.com

Hello

I created a report to show trending of data from month to month. I want the
report to always show Jan-Dec. The Months that do not have data are grayed
out. My problem is that when I do not have data for a given month, I can't
run the report. Any recommendations? I'm sure I am having a brein fart here,
but I just can't seem to figure this one out.

By the way, the report is built using 4 seperate cross tab queries that are
joined together and updates a remp table that is used for the source of the
report.

Thanks

"D"
 
Not sure if this is what you want but what I do is in the crosstab query
properties window, where it says Column Headings type: Jan, Feb, Mar, Apr,
etc... also you should have a ByMonth somewhere within the query window.
Hope that helps!
 
Back
Top