Crosstab Report - Variable number of control sources

[M S]

I have a report based on a crosstab query. Each column is "1" through "10"
calls. I made my report with fields for each one, 1 through 10. However,
sometimes there are only 5 or 7 calls when I need to run the report. But it
errors out and says the control source for the blank values is invalid. For
instance, if there are 9 calls rather than 10, my report won't open because
"10" isn't a valid control source.

Any ideas?

 

[Duane Hookom]

You can add all possible column heading values to the Column Headings
property of the crosstab query.

 

[M S]

I don't know why I haven't thought of that... it worked great, thanks!

-M