Need Help With Variable Column Report! 1

[DCBBB]

I have a report bound to a table that will change with each new parameter. The table is created with a make-table query off of a crosstab, so the number of columns may vary. The fields in my report are bound, so when the report is run, if columns of data are missing, I get the parameter prompt looking for the missing field. How do I:
1) Get rid of the prompt?
2) Hide columns if they don't exist?
I've been experimenting with If statements in the control source of the field and with code in the OnFormat event of the Detail Section, but I can't figure it out!
Any help would be greatly appreciated!!! Thanks.
D

 

[DougP]

How many reports do you need to end up with??

make a report for each differnt type????
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[DCBBB]

Hi Doug,
There are about 10 reports, but I'll try your suggestion - nothing else seems to be working.
Thanks!
D