Crosstab queries as recordsource for Report

[kfschaefer]

How do I handle the changing number of fields created by a
crosstab query and have the correct fields displayed in a
report.

Do I need to create a report on the fly, if so how to I do
that?

 

[Duane Hookom]

The most flexible solution is found in the samples at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

 

[Ben]

You can refer to the EmployeeSales report in the sample
Solutions database (Access 97).

Good luck!

 

[Duane Hookom]

I would not use the solution proposed in the Solutions.mdb. A more flexible
and faster method is described in the demo at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4