Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Reports

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-08-2005, 04:46 AM
Guest
 
Posts: n/a
Default 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?
Reply With Quote
  #2  
Old 12-06-2006, 03:02 PM
Novice
 
Join Date: Dec 2006
Posts: 5
jbowers66
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


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


All times are GMT -8. The time now is 03:04 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.