HELP!!
Working on a deadline and this query won't work. Hopefully someone can see something that is obviously. Different criteria apply to different levels . . . any ideas of different OR operator to make this work or do you see something else obvious?
Levels: (IIf([SumofMth Life Pols]>=20,IIf([Bank/Mutual Funds]>=4,IIf([SumOfMth Health LTC]>=2 Or [Fortis/MedSupp]>=4,"Level 3")))) Or (IIf([SumOfMth Life Pols]>=15,IIf([Bank/Mutual Funds]>=3,IIf([SumofMth Health LTC]>=1 Or [Fortis/MedSupp]>=3,"Level 2")))) Or (IIf([SumOfMth Life Pols]>=10,IIf([Bank/Mutual Funds]>=2,IIf([SumofMth Health LTC]>=1 Or [Fortis/MedSupp]>=2,"Level 1"))))

Levels: (IIf([SumofMth Life Pols]>=20,IIf([Bank/Mutual Funds]>=4,IIf([SumOfMth Health LTC]>=2 Or [Fortis/MedSupp]>=4,"Level 3")))) Or (IIf([SumOfMth Life Pols]>=15,IIf([Bank/Mutual Funds]>=3,IIf([SumofMth Health LTC]>=1 Or [Fortis/MedSupp]>=3,"Level 2")))) Or (IIf([SumOfMth Life Pols]>=10,IIf([Bank/Mutual Funds]>=2,IIf([SumofMth Health LTC]>=1 Or [Fortis/MedSupp]>=2,"Level 1"))))