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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to Combine reports to's to a single box? 0
Automatically insert "Continued" in footer based on existing STYLEREF 2
Getting Radio Buttons to work, that are inserted via AutoText 0
How to display multiple IIf results in one column 0
Yes/No field display options? 1
CrossTab Query How Do I change Column Headings... 2
ASK Field Formatting 1
"Merging" Yes/No Fields in a query (MSAccess 2007) 4

Top