Complicated IIf Statement

M

mate

I have records that contain 3 fields named, "SA1", "SA2",
and "SA3". I want to create a calculated field that will
look at these three fields and if any of them contain the
value, "FF" then have the new calculated field value
be "FF". Any help is greatly appreciated as always.
Thankyou.

mate.
 
M

mate

disregard my other reply. is there a way to have the
field be blank if none of teh fields has the value "FF"
 
J

John Spencer (MVP)

Field: HasFF: IIF(Sa1="FF" Or Sa2 ="FF" Or SA3 = "FF", "FF",Null)

An alternative that may work
Field: HasFF: IIF("FF" in (Sa1,Sa2,Sa3),"FF", Null)
 
Top