Displaying Yes or No rather than 0 or 1

  • Thread starter Thread starter Jerry Anderson
  • Start date Start date
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...
 
You can format the field of use an IIF statement like this --
My_Field: IIF([SomeField] = -1, "Yes", "No")
 
Back
Top