Results 1 to 4 of 4
  1. #1
    Join Date
    May 2016
    Posts
    89
    Provided Answers: 4

    Unanswered: How to Display Intermediate Cumulative Sum By Page Footer

    Hi,

    On a report, how to display


    1. Intermediate cumulative sums by page footer, that is, on
      • Page 1, sum of displayed records ,
      • page 2, sum of displayed records + Page 1 records ,
      • And so on

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    in the page footer,
    add the field ( to be summed)
    set the property : running sum = yes (data tab)
    or
    set the field control source = SUM([field])

  3. #3
    Join Date
    May 2016
    Posts
    89
    Provided Answers: 4
    Thanks a lot for your answer ranman

    But here is a one of my post with solution and more with access db example to upload

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    as ranman256 suggests you can get the page total quite easily

    however to get previosu apges detaisl may require some VBA jiggery pokery

    create the report footer as suggested
    then in the report footer on format section take note of this pages values in a global variable
    then add in the previous page(s) values in an unbound control
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •