IIF Statements

[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

 

[Alphonse Giambrone]

=IIf(isNull([5yr]),"na",IIF([5yr]<51,"o","x"))

 

[fredg]

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

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