Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Supress Detail

Posted on 2016-11-12
4
Medium Priority
?
57 Views
Last Modified: 2016-11-12
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
Comment
Question by:pdvsa
  • 2
4 Comments
 
LVL 22
ID: 41884607
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
 
LVL 52

Accepted Solution

by:
Gustav Brock earned 2000 total points
ID: 41884683
Go to design view of the report:

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

That's it.

/gustav
0
 

Author Closing Comment

by:pdvsa
ID: 41884707
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
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 41884709
You are welcome!

/gustav
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question