Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-15-2014, 07:13 AM   #1
Czeszyn
Newly Registered User
 
Join Date: Oct 2014
Posts: 128
Thanks: 34
Thanked 1 Time in 1 Post
Czeszyn is on a distinguished road
Taking just the totals.

Hello, I was wondering if there is a way to just take the totals out of my query, and have just those totals display in my report. I am not an advance users so please the simplest way would be nice.

Czeszyn is offline   Reply With Quote
Old 12-15-2014, 08:48 AM   #2
MarkK
Super Moderator
 
MarkK's Avatar
 
Join Date: Mar 2004
Location: Vancouver BC
Posts: 7,761
Thanks: 10
Thanked 1,289 Times in 1,227 Posts
MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all
You can set the Details section of the report to Visible = False, so you don't show every record, you only show the headers and the footers, which commonly contain the summaries.
__________________
formerly known as lagbolt | Windows 10 | Access 2010 | Visual Studio 2013 | "Institutions have a vested interest in perpetuating the problems to which they are the solution." - Clay Shirky
MarkK is offline   Reply With Quote
The Following User Says Thank You to MarkK For This Useful Post:
Czeszyn (09-22-2015)
Old 12-16-2014, 12:39 PM   #3
Czeszyn
Newly Registered User
 
Join Date: Oct 2014
Posts: 128
Thanks: 34
Thanked 1 Time in 1 Post
Czeszyn is on a distinguished road
Re: Taking just the totals.

Quote:
Originally Posted by MarkK View Post
You can set the Details section of the report to Visible = False, so you don't show every record, you only show the headers and the footers, which commonly contain the summaries.
Thank you. I used that in some parts, forgot you can hide things? HaHa.

Czeszyn is offline   Reply With Quote
Reply

Tags
query , reports , totals query

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Totals Query/sums/grand totals thsoundman Queries 17 04-16-2013 11:24 AM
Displaying previous totals, and current totals, on a report Janzi Queries 0 12-05-2011 11:17 AM
Dynamic Report - Preview Totals differ from Printed Totals Longworth2 Reports 5 06-16-2009 01:18 PM
[SOLVED] Totals in Report returns totals for all records dcg2122 Reports 1 11-09-2003 03:52 PM
[SOLVED] Taking acount cubsrlb Queries 2 05-14-2003 12:10 PM




All times are GMT -8. The time now is 06:07 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World