Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Supress Detail

Posted on 2016-11-12
4
Medium Priority
?
60 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 24
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

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…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

572 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