Hi,
Hope this is the right place to ask this, as the issue is exporting to Excel from a report.
I have a report that contains a sum field that is within a group section (it is created within the report and not part of the underlying query) that I would like to export to Excel and have the currency formatting within Access transferred to Excel. All of my formatting attempts (ccur, format currency, etc..) within the report have failed to bring the currency formatting over to Excel. Is there a way to do this?
The Excel spreadsheet needs to keep the report's grouping levels (2 levels). So, I have used the report (better grouping abilities) instead of a query to export the data to Excel.
Thanks so much for your assistance.
Sydney
Hope this is the right place to ask this, as the issue is exporting to Excel from a report.
I have a report that contains a sum field that is within a group section (it is created within the report and not part of the underlying query) that I would like to export to Excel and have the currency formatting within Access transferred to Excel. All of my formatting attempts (ccur, format currency, etc..) within the report have failed to bring the currency formatting over to Excel. Is there a way to do this?
The Excel spreadsheet needs to keep the report's grouping levels (2 levels). So, I have used the report (better grouping abilities) instead of a query to export the data to Excel.
Thanks so much for your assistance.
Sydney
