iif function (1 Viewer)

[yanliang]

I need to create a query for certified employees.
the certified field is called "certified?" and is Yes/No
If an employee is certified I need to input "Eligible for Bonus" if not "Enroll in Summer MG Class"

I inserted in a function
iif([Certified?]="Yes","Eligible for Bonus", iif([Certified?]="No", "Enroll in Summer MG Class"))
but when I run the field it keep showing up #error.
I don't know why.

 

[arnelgp]

only test for 1 condition.
Yes/No field can either be True or False (Yes or No).

iif([Certified?], "Eligible for Bonus", "Enroll in Summer MG Class") As Remarks

 

[yanliang]

thankyou so much

 

[arnelgp]

you're welcome!

 

[Pat Hartman]

Although arne's suggestion is correct that you only need to check for one value, the actual problem is that you were using "Yes" instead of True or -1 for a Yes/No field