Dynamic Reporting in Access

[Chip]

I am attempting to run a report against a query that is
built off of two queries and a crosstab query. Every time
the columns change in the crosstab query, it changes my
final query query. In turn, this issues a message in my
report saying that certain fields are no longer available,
or more closely, do not exist.

Any help on making this report more dynamic?

 

[Duane Hookom]

There are various solutions in the sample apps/downloads at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.