Yes/No Check Box to display Yes or No

[Lisa Perry]

Hello,



I have a table in which I use a checkbox for one field that I use on a form. When I run a query on this data I get -1 for yes and 0 for No - is there a way to get this to display Yes or No (I don't want True of False either)...I even tried an update query and if did not seem to work...

Thank you for any help.

Lisa

[ketbdnetbp]

Lisa -

In your query, you could try using...

YorN: IIF([Nameofcheckboxintable]= -1,"Yes","No")

in a new column in the field row.

See if that produces the desired results.

All the best,

Jim

[Lisa Perry]

Thank you Jim, I honestly just thought of that myself and it worked...but I certainly appreciate your help!

Lisa

Lisa -

In your query, you could try using...

YorN: IIF([Nameofcheckboxintable]= -1,"Yes","No")

in a new column in the field row.

See if that produces the desired results.

All the best,

Jim