Eliminate field values

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
happydermis
Posts: 63
Joined: Tue Oct 10, 2017 12:44 pm

Eliminate field values

Post by happydermis » Fri Feb 25, 2005 10:01 am

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
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Eliminate field values

Post by kfleming » Fri Feb 25, 2005 5:16 pm

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

happydermis
Posts: 63
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Eliminate field values

Post by happydermis » Fri Mar 04, 2005 9:32 am

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

Post Reply