pdvsa
asked on
Supress Detail
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
EESupress.accdb
SELECT Import_FC_Archive.[Total Incoming], Import_FC_Archive.[Total Expenses], Import_FC_Archive.Date_App
I have attached a sample db.
grateful for your help
EESupress.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Crystal. Gustav's solution was something i could implement quickly. I forgot there was a property i could set to solve my problem.
Thanks once again Gustav.
Thanks once again Gustav.
You are welcome!
/gustav
/gustav
Open in new window
WHERE MyCalculatedFieldname is whatever you want to call the calculated field. If you use spaces or special characters, MyCalculatedFieldname must be surrounded with [square brackets]