IIF error

[Maric771]

I'm trying to set up a pass/fail field with multiple conditions

If the order field starts with 10 or if the 2 year total field is < the 1996
field then update the field with pass, otherwise update with fail.

Pass 1996: IIf([EP 1996 Passed Orders]![Order]="10*" Or ([2year total]<[EP 5%
Test]![1996],"Pass","Fail"))

I know it's probably a simple error, but I'm just not seeing it.
Any help would be appreciated.

 

[Ken Snell MVP]

Pass 1996: IIf([EP 1996 Passed Orders].[Order] Like "10*" Or [2year
total]<[EP 5%Test],[1996],"Pass","Fail")

 

[Maric771 via AccessMonster.com]

Thank you - it's greatly appreciated

Pass 1996: IIf([EP 1996 Passed Orders].[Order] Like "10*" Or [2year
total]<[EP 5%Test],[1996],"Pass","Fail")

I'm trying to set up a pass/fail field with multiple conditions

[quoted text clipped - 8 lines]

I know it's probably a simple error, but I'm just not seeing it.
Any help would be appreciated.