iif or condition syntax ?

[techexpressinc]

I am trying to a new field based on two other fields:

The new field is "AnyTestingNDTor5500", the field's value is "Yes" if either the two individual plan testing parameters are set to "Yes".

Below is what I am trying and getting a syntax error.


CODE
AnyTestingNDTor5500:iif(([Plan Testing] = "Yes" or [5500 Forms] = "Yes"),"Yes","No")


Thanks
Russ


--------------------

Have a Great Day
Russ Neuman, FLMI, ASC
Certified MS-Office Specialist

 

[techexpressinc]

Solved!
AnyTestingNDTor5500: IIf(([Plan Testing]="Yes" Or [5500 Forms]="Yes"),"Yes","No")