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

  • General discussion

  • 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

    • Changed type technet65 Monday, June 13, 2016 2:16 PM
    • Changed type David_JunFeng Wednesday, June 22, 2016 9:42 AM
    • Changed type technet65 Wednesday, June 22, 2016 9:53 AM
    • Changed type technet65 Wednesday, June 22, 2016 9:53 AM
    • Changed type technet65 Wednesday, June 22, 2016 9:55 AM
    Sunday, June 12, 2016 4:20 PM

All replies

  • 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

    Sunday, June 12, 2016 5:05 PM
  • Hi Tom, 

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

    Sunday, June 12, 2016 5:10 PM
  • >>>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.
    Monday, June 13, 2016 2:37 AM