J
JoeA2006
I am trying to find a good way to export data to anexcel sheet from multiple
subreports. Basically I am trying to take the data on an Access report and
also show it in Excel. The Access report is based on at least 10 subreports.
The "analyze with Excel "function does not work for this purpose. Is there a
way to to program Access to place the data from each subreport on a
spreadsheet in a particular order based on 2 criteria. I also have to format
the spread sheet with subtotals and so forth.
I have also tried saving the Access report as html and performing a web
query, but the data is misalligned.
subreports. Basically I am trying to take the data on an Access report and
also show it in Excel. The Access report is based on at least 10 subreports.
The "analyze with Excel "function does not work for this purpose. Is there a
way to to program Access to place the data from each subreport on a
spreadsheet in a particular order based on 2 criteria. I also have to format
the spread sheet with subtotals and so forth.
I have also tried saving the Access report as html and performing a web
query, but the data is misalligned.