Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 63
  • Last Modified:

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_Append, 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
0
pdvsa
Asked:
pdvsa
  • 2
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you can define a calculated field:
   SELECT nz(Import_FC_Archive.[Total Incoming]) + nz(Import_FC_Archive.[Total Expenses],0) as MyCalculatedFieldname, etc

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]
0
 
Gustav BrockCIOCommented:
Go to design view of the report:

Select Detail section Properties, Format.
Set property Visible: No
Save report.

That's it.

/gustav
0
 
pdvsaProject financeAuthor Commented:
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.
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now