Results 1 to 2 of 2
  1. #1
    Guest

    Collection of Page Total

    I got a bit stuck on the work I am doing. I am trying to collect all
    the page total and listed it on a page via subreport using TOC methods


    at GroupFooter Section. Then I wish to summarize the listing page
    totals as a grand total on the same unbound textbox (i.e. PageAmt) at
    PageFooter Section where I have introduce earlier for page total.
    Though I have use "running sum" and "Nz" but I still unable to get
    Grand Total. Can anyone help me how to control the unbound textbox
    "PageAmt" to read page total of every pages until it reach GroupFooter
    and read subreport total, instead?

  2. #2
    Join Date
    Dec 2006
    Posts
    5
    It's probably possible to do that, but if I had a report like that I'd probably write the page totals to a table and then print the table at the end as a summary.

    jb

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-12-2009, 09:55 AM
  2. total in textbox
    By micfly in forum Access
    Replies: 3
    Last Post: 11-09-2008, 11:24 AM
  3. Total records printed
    By LesleyA in forum Queries
    Replies: 3
    Last Post: 08-04-2008, 03:53 AM
  4. Total no of days in a month
    By wasim_sono in forum Forms
    Replies: 4
    Last Post: 10-15-2006, 01:05 PM
  5. :?: newbie...grand total?
    By PnerraD in forum Access
    Replies: 1
    Last Post: 08-24-2006, 06:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums