Hi all. Can someone please help with this problem? I have a code module in Access that runs a query that produces a one-record table and that record contains a total. Then the code runs this on an Excel Spreadsheet:
DoCmd.TransferSpreadsheet acExport, 8, "TOTAL_TABLE", "SpreadsheetName", False...