Experts, I have the following SQL in a report. I am wanting to suppress the details [Total Incoming] and [Total Expenses] and only show the sum on [Total Incoming] and [Total Expenses]. Its an import from Excel. I am not sure how to do this in the report.
SELECT Import_FC_Archive.[Total Incoming], Import_FC_Archive.[Total Expenses], Import_FC_Archive.Date_App
end, Import_FC_Archive.Date, Format([Date_Append],"mmmm
yyyy") AS YearMonGroup FROM Import_FC_Archive;
I have attached a sample db.
grateful for your help