Exporting an Access report into Excel

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
 
K

Kevin B

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
Access MSACCESS - Sorting report based on field calculated in the report 0
Access MS Access Listbox not saving to bound field 0
Exporting data to excel and maintaining info 3
two questions on exporting from a form 3
User selection of Fields for a report 1
How can I search/replace weird command in text imported from Summation database? 4

Top