Displaying Yes or No rather than 0 or 1

J

Jerry Anderson

I have a query that includes a Yes/No field. When it displays the results in
a list box, I want it to display Yes or No, rather that 0 or 1. I'm sure this
must be easy, but...
 
K

KARL DEWEY

You can format the field of use an IIF statement like this --
My_Field: IIF([SomeField] = -1, "Yes", "No")
 
Top