Data Type "Yes/No"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some data fields which use the Yes/No data type.

I am now trying to generate an excel file using a report with records
containing these data types but the export ignores these fields altogether on
export even though the Access report shows them as "Checkboxes"

How can I get the Yes/No fields to export as "Yes" or "No"?
 
Create a query with a "calculated field". Use this field in lieu of the
Yes/No field.

Example:
ExportField:IIf([YesNoFieldName], "Yes", "No")
 
Back
Top