Export query to excel with subtotal

Topic

New Reply

I am current use the following codes to export a query to excel file:

DoCmd.TransferSpreadsheet acExport,acSpreadsheetTypeExcel97, “qry_Master”, “c:Master.xls”, True

There’s a field in qry_Master call “status.’ Now I want to have a subtotal of “Yes” and “No” of status field when I export query to excel.

What needs to be modified in this code to achieve what I’m after?

Thanks,

Reply | Quote

Replies

One option would be
– Create a totals query that groups by the status fields and calculates the subtotals.
– Create a union query that combines your original query and the totals query.
– Export the union query.

Another:
– Use Automation to open the exported workbook in Excel from Access, and add the subtotals there.

Reply | Quote

Thnaks, Hans.

Reply | Quote