Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 page wise summery of report in ms access

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-21 : 08:51:27
balu writes "I getting summery of all units in last page of reports. But i want to get page wise summery of all page,in last page before unit summery. (eg 1 st page summery, 2 nd page summery)"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2006-02-21 : 08:56:28
This site:

http://www.mvps.org/access/

has all kinds of good stuff, this one might help you:

http://www.mvps.org/access/reports/rpt0004.htm

I vaguely remember there being a more detailed description of how to do it, but I can't find it. Basically it involves setting up the unbound text box, and then adding code to the OnPage event to reset the totals when a new page is created.
Go to Top of Page
   

- Advertisement -