IIF Statements

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am trying to do write a multiple IIF statement in a TEXT
BOX on a report. Does anyone have an example? mine is not
working for some reason. Here is what I am trying to do:

IIF([5yr]<51,"o","x")

However, if the field is blank I need it indicate this by
placing an "na" on the report

thank you for your help
 
I am trying to do write a multiple IIF statement in a TEXT
BOX on a report. Does anyone have an example? mine is not
working for some reason. Here is what I am trying to do:

IIF([5yr]<51,"o","x")

However, if the field is blank I need it indicate this by
placing an "na" on the report

thank you for your help
Click to expand...

=IIf(IsNull([FieldName]),"na",IIf([fieldName]<51,"o","x"))
 
Back
Top