Report : How to display intermediate cumulative sum by page footer and total sum on report footer?

Question

Hi 

On a report, how to display

1. intermediate cumulative sums by page footer, that is,  

• on the first page sum for the first page displayed records ,
• On the second page,  sum of displayed records on the second page + records of the first page,
• And so on

1. total sums on report footer, that is, sums of all fields values  the detail area

Thanks for your help

Answer 1

I don't think there is an easy way to show cumulative values by page. Maybe one alternative is to show cumulative results for each record, which is readily available using the Running Sum feature.

---

-Tom. Microsoft Access MVP

Answer 2

Hi Tom, 

Thanks for your response but Is there or not a way?

Answer 3

>>>Thanks for your response but Is there or not a way?

According to your description, you could put a control in the details carrying the amount to be summed, and make it a Running Sum Over All and invisible. Name it something appropriate. Then put a control in the page footer calling the running sum control name. This will give you the overall cumulative amount for everything through each page, refer to below helpful link:

http://www.utteraccess.com/forum/index.php?showtopic=2037400

Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.