Printing variable number of columns

[marathonlady]

Anyone have any code for printing a variable number of columns on a report, ie., at least 2 cols up to 31 columns?

 

[Rich]

Did you not investigate the CrossTab option? It would need to be a dynamic one though for which there have been several posts here

 

[marathonlady]

Reply to Rich

Rich,

So how do I approach the cross tab option? A cross tab query?

Please explain.

 

[Rich]

Yes, you need a dynamic report based on a parameter crosstab query.
Download the qrySamp from Microsoft, there are examples in it which should help you

 

[marathonlady]

Reply to Rich again

I'm a semi-novice, where is the microsoft qrySamp located for me to download?