IIF Statement containing an OR operator

[Adams]

Would you look at this IIF statement and tell me what I am doing wrong.

ServiceFee: IIf([Intkt] Like " 952*","SERVICE FEE/NON-ARC AIR" Or IIf([Intkt] Is Null And [tblNebExt].[invaln] Is Null,"NON-ARC AIR"))

 

[lespaul]

I think this is what you are wanting to do:

iif([Intkt] Like " 952*", "SERVICE FEE/NON-ARC AIR", iif(]Intkt] Is Null AND [tblNebExt].[invaln] Is Null,"NON-ARC AIR", "Error"))

Leslie