Extracting information from Access Report to go to Excel Sheet (1 Viewer)

[proballin]

I have a macro that I run in Access. It runs through some appends and deletes and finally opens a report showing some sums. What is the best way to take each sum for a location and export it to a specific row in an excel sheet?

 

[DCrake]

Are the calculations (sums) done at query level or are they done in the report?

If the latter then modify the query to perform them there then use the query to export to Excel.

David

 

[proballin]

Sums are done at the report level but I was able to modify it to take place in the query. Nevertheless I still am unsure as to how I can export the results and have them placed in the appropriate row in excel. They have to be placed based on it being the same location and same time.

 

[rmunteanu]

Hi. I am experiencing approximately the same problem. I have a report that groups data by a category and I need to export to excel respecting the format of the report: the category subtotal row detail is displayed in the same column with data (no indent).
I don't have the solution. I would appreciate some help
Thanks.