Multiple expressions

  • Thread starter Thread starter Krista
  • Start date Start date
K

Krista

in the report I am working on I have a lot a expressions. In a few of the
fields I need multiple expressions. The first expressions read: if this
report is on this person(s) insert NA. That part works fine. But now I am
trying to add a second part that reads: If the value of this field is 0.00%
insert NP. I can not get that to work any ideas?
 
Try,

=IIf([Field] = 0,"NP",[Field])

That should check to see if the Field is equal to 0, if it is then it puts a
NP, if not it puts the field...

Drew
 
Back
Top