Exporting to Excel looses Report subtotals (footers)

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have an Access report that makes extensive use of the
Source, Page, and Report footer sections to do
calculations. When I export this report to Excel, all of
the data in the footers (subtotals, calculated fields) are
lost- only the raw data contained in the Detail section is
exported.

Is there a way to retain the subtotals, or are they
automatically lost when exporting to Excel.

Thank you.
Tom
 
Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

When you export a report that contains totals to Microsoft Excel, the total
fields are missing in Excel.

An alternative method is to save the report to Rich Text Format (RTF), to
open it in Microsoft Word, to copy the data, and then to paste the data
into Excel. For an example of how to do so, follow these steps:



1. Open the sample database Northwind.mdb.

2. In the Database window, click Reports, click the "Employee Sales by
Country" report, and then click Preview.

3. When you are prompted for the date parameters, type the following dates:

- Beginning Date: " 8/1/96" (without the quotation marks)

- Ending Date: "8/30/96" (without the quotation marks)

4. On the File menu, click Export.

5. In the "Save as type" list, click Rich Text Format.

6. Make note of the folder to which you are saving the report, and then
click Save. Note also that the name that Access assigns to the saved
report is "Employee Sales by Country.rtf."

7. Quit Access, and then start Microsoft Word.

8. In Word, on the File menu click Open.

9. Browse to the folder in which you saved the "Employee Sales by
Country.rtf" file, and then open it.

10. On the Edit menu, click Select All.

11. On the Edit menu, click Copy.

12. Start Microsoft Excel, and then open a new workbook or open a clean
sheet in an existing workbook.

13. On the Edit menu, click Paste.



Note that Excel displays all the data, including the totals.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
 
Back
Top