Thread: iff function
View Single Post
  #1  
Old April 27th, 2004, 09:03 PM
debdeb
external usenet poster
 
Posts: n/a
Default iff function

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)