Check from Column from a report

[kusumerumaal]

Hello,

I need help with Access reports. Here is my senario:

I am using crosstab query which means that the number of columns in the end query result varies depending on the data. My report looks up field values from this query.

What I want to do:
I want the field in my report to look if the column exists. If yes then get that value else put blank. I have never manupulated reports so clueless as to what code to put and where and would need specific details.

I have Access 2003. Would really appreciate any advice. Thanks!

 

[pbaldy]

Search on "dynamic crosstab". I use code from the Access Developer's Handbook which I think is better, but there's also this:

http://support.microsoft.com/kb/328320