Dynamic Crosstab reporting

[Techno2001]

I have created a crosstab query that has parameters assigned to it from a form. I want a report that will change whenever the crosstab query changes.

My problem is the report. Access "hard codes" the column headings into the report. When the crosstab query changes, the report still looks for the original column headings. How can I build a report off of the crosstab query that will change with the query?

Techy2000

 

[tvpcman]

I had the same problem. Here is a link to a "samples" database that has some really good examples including "Dynamic Crosstab headings" under the "advanced reports" category.

http://msdn.microsoft.com/library/officedev/bapp2000/bapp2000.exe

This will take you to a better description of the download.

http://msdn.microsoft.com/library/officedev/bapp2000/mdbdownload.htm

I used a couple of these. They work like a charm.