i am using this code to export the query result to Excel. The spreadsheet opens and i elaborate the data in excel.
The query includes numeric values in the field “Amount”. How to i extend below code to also include the SUM for the column “Amount”.
Private Sub Excelexport_Click()
DoCmd.OutputTo acQuery, "AmountReportQuery", "MicrosoftExcel(*.xls)", "c:\MyReports\Amountreport.xls", True, ""
I took a look at Mr Bob Larsson's excellent example..but i cannot identify anything in that code solving my question..