Hi all,
I am using the below code to export the query result to excel.
Private Sub Excelexport_Click()
DoCmd.OutputTo acQuery, "AmountReportQuery", "MicrosoftExcel(*.xls)", "c:\MyReports\Amountreport.xls", True, ""
The query includes two fields. “Amount” (Column A in the spreadsheet) and “Amount2” (Column B in the spreadsheet). Both fields are numeric.
How do i extend my code to also create the SUM for column A and B?
Thanks!
I am using the below code to export the query result to excel.
Private Sub Excelexport_Click()
DoCmd.OutputTo acQuery, "AmountReportQuery", "MicrosoftExcel(*.xls)", "c:\MyReports\Amountreport.xls", True, ""
The query includes two fields. “Amount” (Column A in the spreadsheet) and “Amount2” (Column B in the spreadsheet). Both fields are numeric.
How do i extend my code to also create the SUM for column A and B?
Thanks!