IIF, ELSE

  • Thread starter Thread starter Tim Ramas
  • Start date Start date
T

Tim Ramas

On a report, I want to show one of three different messages depending on the
value in a specific field.
I can make seperate fields using IIF:
=IIf([Support]=1,"No support is available for this feature.","")
=IIf([Support]=2,"Support is available through our Tech Support
department.","")
=IIf([Support]=3,"All inquiries must be directed to our Professional
Services group.","")

How can I combine those three into one IIF/ELSE statement?
 
Tim said:
On a report, I want to show one of three different messages depending
on the value in a specific field.
I can make seperate fields using IIF:
=IIf([Support]=1,"No support is available for this feature.","")
=IIf([Support]=2,"Support is available through our Tech Support
department.","")
=IIf([Support]=3,"All inquiries must be directed to our Professional
Services group.","")

How can I combine those three into one IIF/ELSE statement?
Click to expand...

=Choose([Support],"No support is available for this feature.","Support is
available through our Tech Support department", "All inquiries must be
directed to our Professional Services group.")
 
Back
Top