I have four queries that need to be placed in the same Excel file. 3 of the queries need to be totaled. When I export individually they carry over the totals from the query, but when I use the button that triggers the [DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml,] the Totals do not flow to the file.
I need to either export the queries one at a time into the same file or find code to include the totals on the Transfer.
Can someone help