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

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

Access how do you set a yes/no data type as required? 0
Yes/No displayed after merge with MS Word 2
Exporting to word misses off data 4
Exporting Yes/No field to Excel 1
Canshrink question!! 2
yes/no total 4
sum multiple yes/no checkbox fields 5
yes/no checkboxes 3

Back
Top