Importing checkbox information from Access Reports into Excel

[Kristina Hangs via AccessMonster.com]

Hi there,

I have a database that includes a lot of checkbox (yes/no) information.

Because there is so much checkbox info, I need to reproducee my reports into
an Excel format.

However, after having generated the report in Access and clicked on Analyse
with Excel, every other field comes up in the Excel spreadsheet except the
checkbox information. Every single c/box field has been removed. How can I
overcome this?

Krissy in Melbourne

 

[Duane Hookom]

I find it hard to believe that Excel will report better than Access but I
guess there are times when this works.

Have you considered use MSQuery to pull your table/query into Excel? Or, you
can change your data in the report's record source to something you want to
see in Excel.