Data Type "Yes/No"

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"?
 
W

Wayne Morgan

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

Yes/No displayed after merge with MS Word 2
yes/no checkboxes 3
sum multiple yes/no checkbox fields 5
Exporting to word misses off data 4
Access how do you set a yes/no data type as required? 0
file export of report ... "Yes/No" data type fields 2
Export to Excel Cuts Off Data 1
Canshrink question!! 2

Top