IIf statement problem

[Joe8915]

Working in a query I have this statement, I'M getting error message

Test: IIf([contracttype]="GS" And [Award Amt]<"150000","No eval")

The result should be
Contract Type equal GS
less than $150,000.00
No eval

 

[Dairy Farmer]

You are refering to 150000 as text and I guess it should be a number. Remove the " " (highlighted in red) and it works.

Wrong
IIf([contracttype]="GS" And [Award Amt]<[COLOR=red][B]"[/B][/COLOR]150000[B][COLOR=red]"[/COLOR][/B],"No eval")
 
Right
IIf([contracttype]="GS" And [Award Amt]<150000,"No eval")

 

[Joe8915]

Thanks for the quick reply and thanks ever so much