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.
