Make a report ignore or hide a field

[Deegs]

Is there anyway to make a report ignore or hide a field if it does not exist. The man’s crazy you may say, databases need fields - but!

I am using a Crosstab query – which reports relative dates.

I wish to report on latest number of items required by project. This means that some projects will go further in the past than others.

My dilemma is that on one project I may have relative months Mth5, Mth4,Mth3,Mth2, Mth1 and on an other project Mth3,Mth2, Mth1 only. The report states the Mth4 or greater cannot be found as a valid field name or expression.

Is there a way to kid the report or an expression tell it that if a Mth does not exist to print a “ “.

As always help is very much appreciated from you all.

This thread was placed as a follow on in MS Queries, but I realized it needs to be in MS Reports – soz if you have seen it twice.

Cheers, Mark…..
“Life IS like a box of chocolates”

 

[Deegs]

This query has been solved. Thx.

 

[traycee]

Hi!
I have the same problem. If you don't mind, how did you solve this?
Thanks

 

[traycee]

Never mind. I figured it out. Or at least I seem to have done so. I opened the properties dialog of the crosstab query and specified the column headers. For the column headers, I used the exact names I need to use for my fields.