Reports generated from Corss tab query (1 Viewer)

[joeserrone]

Hello everyone,
Can I create a MS Access Report with a cross tab query as my underlying source? Is there anything special or different I have to do when dealing with a cross tab query vs. a simply Select query?

Thanks

 

[pbaldy]

Sure; I have a number of them. The wrinkle is that if the fields are dynamic, the report needs to accommodate them. I use a method from the Access Developer's Handbook, if you have access to that.