Yes/No Data on Report

[Johnny Drama]

Hi All,

I've got a table that has several yes/no data type fields. I'm trying to the data into a report and show either yes or no as opposed to -1 or 0. Any thoughts?

 

[bob fitz]

Create query for the report using your data table and create a field in the query. Something like:
YesNo:IIF([YourField] = -1,"Yes","No")

 

[vbaInet]

Or you can use the Format property:

http://office.microsoft.com/en-gb/access-help/format-property-yes-no-data-type-HA001232749.aspx

 

[Johnny Drama]

Ugh. So simple. **Beating my head on desk**

Thanks. Sorry for wasting your time.