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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA, Loop, array, cut and paste 1
extract 3 numbers from a string 0
IIF Function Within A Query 6
Complicated Calculated Field Logic 0
Nesting IIf Statements in Microsoft Access 2000 4
Counting A's in a table column 1, F's in column 2, etc... 3
Multiple IIf statements 2
Using a Yes/No field to trigger a calculation in another field - J 6

Back
Top