Access 2000 report subtotals not exporting to Excel

C

Carolyn

When I use either "Export" or "Analyze with Excel" to
export a report with grouping and subtotals to Excel, the
group footer and it's subtotals does not get included in
the Excel file.

This worked with Access 97 and works on Access 2002 but
does not work on Access 2000. I have searched but cannot
find this problem elsewhere. I have used the same report
on all Access versions, have made it a very simple report,
etc. but it appears that Access 2000 exports with no group
footer row.

Has anyone else seen this? I need a subtotal as per the
report groupings to be automatically generated in the
Excel file which is created by the export.

Thanks and regards
C.
 

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

Issue Exporting a report from Access to Excel 0
Access 2002 change report header text 0
Export Access Report to Excel keep format 4
Export to XML - error 31532 0
Export MS Access report to single html 1
Missing info when exporting report to txt file 2
Some of the sum totals are exporting to Excel 0
Export Report with Graph to Excel error 2495 1

Top