Exporting Access Reports

How can I export an Access Report into a spreadsheet and get all the detailed data and subtotals and totals I need with the data under the correct column headings?

I have a huge monthly General Ledger Report that Accounting needs in a spreadsheet. If I export the report – Access is really only exporting the Query which has no totals and subtotals.

I’ve tried exporting the Report as a CSV, TXT, RTF. All make it difficult to give them a spreadsheet with totals and subtotals and
all the columns aligned just right like the report.