-1 to a Yes

[fenhow]

Hi, is there anyway in a query to convert the -1 or 0 to a yes or no in the result?

Data derived from a checkbox.

Thanks.

Fen How

 

[Khalid_Afridi]

In query builder use IIF([SomeFeild]=-1,"Yes","No")

 

[fenhow]

Brilliant! Thanks so much.

Fen How

 

[Khalid_Afridi]

you are welcome Fen