Report Cross Tab

[Hemish]

Hi,

I am a bit confused as i have a query which is a cross tab and i want to creat a report of it. Only problem is as its a cross tab the headings change all the time eg

April 2007, May 2007, June 2007

If i run the report again the headings may be different as the data would of been updated.

How I can i link this is Access Reports as the control source in the report will always be different when i run the report due to the information on the cross tab

Thanks in advance

 

[pbaldy]

I use code from the Access Developer's Handbook if you have access to that book, but there's also this:

http://support.microsoft.com/kb/328320/en-us