Complicated IIf Statement

  • Thread starter Thread starter mate
  • Start date Start date
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.
 
disregard my other reply. is there a way to have the
field be blank if none of teh fields has the value "FF"
 
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)
 
Back
Top