convert -1 and 0 to True and false in the query

[hengsin]

in the query, i put this line of code in pone of the field:
Attrition: IIf([BadgeNoForecast];Yes;No)

But the result displayed when i run the query is -1 or 0. But i don't want this one. I want it's either displayed "True" or "False". Please don't ask me to do in this way:
Attrition: IIf([BadgeNoForecast];"Yes";"No&quot because i have other field in the query, Result. The code for the result will be in this way:
Result: BadgeNoForecast And BadgeNoActual

If i put the line:
Attrition: IIf([BadgeNoForecast];"Yes";"No&quot
it will give me trouble because "Yes" or "No" will become string, not the Boolean anymore. I will having difficulty.

 

[hengsin]

i already know how to solve my problem. Thanks for the person wish to help me