I create a table that contains sales data for my different stores. The table
will contain different store data depending on the limits applied when
creating the table.
I use a cross-tab query to layout the data in columns. The problem is the
table has changing data, the column heading in the cross-tab change. One time
the columns might be stores 1,2 and 3 and the next time it might be stores
4,5 and 6.
Since the column headings can change depending on how the table was built, I
do not know how to write a single report that will print the results of the
cross-tab.
Any suggestions?
Thanks....
Duane Hookom - 14 Oct 2004 16:54 GMT
There are some sample reports that do this at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Check out Crosstab.mdb
for the specific solution.

Signature
Duane Hookom
MS Access MVP
--
> I create a table that contains sales data for my different stores. The table
> will contain different store data depending on the limits applied when
[quoted text clipped - 12 lines]
>
> Thanks....