Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-03-2019, 05:37 AM   #1
Cubsm22p
Newly Registered User
 
Join Date: Feb 2018
Posts: 36
Thanks: 5
Thanked 0 Times in 0 Posts
Cubsm22p is on a distinguished road
Sum on a report

I have some fields on my report that get totaled in the date footer, but i want to have a grand total at the bottom of the page is this possible.
rothelp.PNG
34433.PNG


Last edited by Cubsm22p; 04-03-2019 at 05:44 AM.
Cubsm22p is offline   Reply With Quote
Old 04-03-2019, 06:19 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,357
Thanks: 0
Thanked 742 Times in 727 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: Sum on a report

I add an extra column ,say Header: 'My Report'
make it the outer most grouping ,
sum the Grand Total in this.
Ranman256 is offline   Reply With Quote
Old 04-03-2019, 07:22 AM   #3
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,126
Thanks: 13
Thanked 4,078 Times in 4,013 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Sum on a report

Try the report footer instead of the page footer. Totals in the page footer require code, unless something has changed.

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report creating extra pages based on number of sub report entries NLW-John Reports 5 11-01-2018 12:33 AM
[SOLVED] Change report filters and report label caption based on form command newdistrict Reports 6 07-23-2017 12:52 PM
Open report button to select data from 7 list boxes and present in a report Gavin59 Forms 19 03-07-2016 07:16 PM
[SOLVED] Open sub report from main report by selecting report name scopes456 Reports 3 12-15-2015 11:01 AM
Does MS Access Report support Hide/Show fields at the Report View time? accesser2003 General 3 06-13-2014 06:15 AM




All times are GMT -8. The time now is 07:33 AM.


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