Eliminate field values

[happydermis]

Hi____Let^s say I can^t eliminate certain values from a report using a query since I have technical problems with R&R - now is there a way to use an IIF statement that will cause certain values from one table simply not to show in the report? ____an example: I don^t want the values from column "PROJNO" from my table to show in my report if they are equal to 0. I used IIF(PROJNO=0,0,PROJNO) but of course I always get the zeros in my report. is there a way to do the job of a query with an IIF statement so these values will not appear in the report?__

[kfleming]

For a numeric field, use Properties and in Format uncheck the box that says show zero.____Kathleen__R&R Support

[happydermis]

Thanks Kathleen,____This was a useful hint. I am still trying to solve my query problem - if it will work I will be able to eliminate the excessive fields by this query - a thing which will save time for my report (it takes a lot of time to produce it...)____Dekers