Exporting an Access report into Excel

  • Thread starter Thread starter Stanley
  • Start date Start date
S

Stanley

I have a report with check boxes on it. When I export it to Excel 2002 I get
all the fields except the checkboxes (I would be happy if a got -1 and 0).
Any ideas less than changing the report to have text boxes for these fields
instead of check boxes.
Thanks,
Stan
 
Aside from converting your check boxes to text boxes that display True/False
there isn't a way to get those check boxes downloaded to your Excel file.

However, you could use MS Query and using the same record source as your
report (table/query) query the data into Excel, which you could then use as a
source for a pivot table report of some type.

Hope this helps...
 

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

Exporting an Access report to Excel 1
Exporting data from Access to Excel 2003 with combo box problem 1
how to export the value of checkbox on a report in to excel 2
Exporting into Excel 2
Exporting Crystal Reports 2
Export excel to ACT 1
Access Microsoft access database(creating a search engine form) 0
#### In Excel spreadsheet after Export from Crystal 5

Back
Top