![]() |
|
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Reset page number and total page number for each group | lisadailey | Reports | 1 | 03-12-2009 07:55 AM |
| total in textbox | micfly | Access | 3 | 11-09-2008 08:24 AM |
| Total records printed | LesleyA | Queries | 3 | 08-04-2008 01:53 AM |
| Total no of days in a month | wasim_sono | Forms | 4 | 10-15-2006 11:05 AM |
| :?: newbie...grand total? | PnerraD | Access | 1 | 08-24-2006 04:28 PM |