iff function

  • Thread starter Thread starter debdeb
  • Start date Start date
D

debdeb

I have a table where there are numbers stored for the
values. How do I get those numbers to print out the
corresponding words in a report. Example 1=yes 2=no
3=sometimes. I have the beginning, but how do I put the
rest in.....
Example if field name is Weather,
=IIf([weather]=1,yes)
 
debdeb said:
I have a table where there are numbers stored for the
values. How do I get those numbers to print out the
corresponding words in a report. Example 1=yes 2=no
3=sometimes. I have the beginning, but how do I put the
rest in.....
Example if field name is Weather,
=IIf([weather]=1,yes)
Click to expand...

As long as the numeric values go from 1 to whatever and there aren't too
many of them you can use the Choose Function.

=Choose(YourField, "TextIf1", "TextIf2", "TextIf3", etc..)

I don't recall, but I think Choose has a limit though. You can also look
at the Switch() function. While either of these would likely be easier to
build (and debug) then nesting Immediate-Ifs I would actually create a
translation table and join to it in my query if there are more than just a
few choices.
 
Look at the Switch and Choose functions in the Help file. They are more
appropriate than the Intermediate If here.
 
Back
Top