Force Column Headings in a Cross-tab query?

[willsaunders]

I've got a problem. I'm trying to use a cross tab query to generate a report. The thing is when data changes the number of column headings changes so the report (or the second query that I use before the final report) can't access the fields that have changed.

Can anyone help with this? Am I being a bit stupid? Is there a better way of going about this?

Cheers,

Will.

 

[jatfill]

The Solutions.mdb database has an example of this...

<A HREF="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bapp2000/html/mdbdownload.asp" TARGET=_blank>Microsoft Access 2000: Building Applications with Forms and Reports
</A>