Results 1 to 2 of 2
2003-03-13, 15:53 #1
- Join Date
- Jul 2002
- Indianapolis, Indiana
- Thanked 0 Times in 0 Posts
Crosstab Query-Multi use (Access 97 SR1)
I would like to use Crosstab Queries/Reports to display snapshots of data for my division chiefs. This is the first time I've really used them. I've generated reports that the chiefs like.
Alas, when I ran the Crosstab against a new set of data, the data returned was not identical to the previous data. As this was the case, the Report that I had designed around the first Crosstab would not work, as the fields and values had changed.
Is there any way to use a "Template" for a Crosstab that will always work for a particular query...even if some fields change?
I don't have the time to completely format a new report for every CT query that I run against new data.
Thanks in advance,
2003-03-13, 16:11 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Crosstab Query-Multi use (Access 97 SR1)
There have been several discussions about dynamic column headings for crosstab reports. If you do a search in this forum with keywords "dynamic crosstab" or "crosstab report" (without the quotes), you will find them. See for example <post#=227580>post 227580</post#>, it has a possible solution and links to other posts with different solutions.