Print text based upon field contents

[Evan Robitaille]

I want to print text based upon the content of the field but need more than the IIF statement. For example, if the field contains an "A" I want to print "Active", "C" I want to print "Closed", "N" I want to print "New", etc.

Thanks in advance for any help. You guys have always had an answer in the past!

 

[llkhoutx]

A nested conditional iif function is what you want.

"A" I want to print "Active", "C" I want to print "Closed", "N" I want to print "New", etc.


=iif([YourFieldName] = "A","Active", _
iif([YourFieldName] = "C","Closed", _
iif([YourFieldName] = "N","New", _
"???????")))

Keep your parentheses balanced.