We help IT Professionals succeed at work.

Export report data to an Excel file - Not all values export

SteveL13
SteveL13 asked
on
I have an Access report which I want to export to an Excel file.  The information exports just fine EXCEPT for three DSum values in the grouped footers.  Can anyone tell me why these Dsum values aren't coming over in the export?

--Steve
Comment
Watch Question

CERTIFIED EXPERT
Commented:
When you export a report in Access to Excel, it will only export the data source of the report.  It is not a formatted dump of the report to Excel (like QuickBooks)
NorieAnalyst Assistant
CERTIFIED EXPERT
Commented:
How are you exporting the report?

Have you considered exporting the data from the report then adding the totals/sums to the Excel worksheet later?
CERTIFIED EXPERT
Top Expert 2009
Commented:
It is generally better to export the report's record source, or possibly a temp table created by a make-table query, in order to convert the calculated values into fixed values.  

Explore More ContentExplore courses, solutions, and other research materials related to this topic.