file export of report ... "Yes/No" data type fields

[snlcoy]

I did File / Export in Microsoft Access for a report to Excel. The "Yes/No"
data type fields are not exported.

Is there a way I can force them to be exported to Excel? I expect them to
be exported with True/False values. Is there way to export them as "check
marks" like they are displayed in the report?

Thanks.

 

[Dennis]

You cannot expect checkboxes (which are a GUI representation of a data value)
to be exported to Excel. Further, why would a person ever export anything to
Excel from Access, well, I don't undertsand that.

 

[Pendragon]

You can export the underlying query of the report to Excel. Yes/No will
translate to True/False for Yes/No. The easiest thing to do is simply run
the query instead of the report and the in the Preview screen, click on the
Analyze with Excel button. This saves the Excel file with the query name in
your default database folder (set in Tools Options).

If the query has filters from a form, open the form and set your data first
before running the query.