Total of items in each page in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a report of many pages (in each page I have a number of items).
I would like to have at the bottom of each page the sum of items that are
on that particular page, and not the total sum of all the report.
Thanks in advance, Mansoor
 
Allen Browne said:
See:
Reports: Page Totals
at:
http://members.iinet.net.au/~allenbrowne/ser-11.html

The article explains how to use the reports events to collect the total for
the page, and display in the Page Footer.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




I did the four lines of code, but something went wrong.It doesn't work.I get an empty result.
Click to expand...
The problem might be in the unbound control?
In the unbound control in the Page Footer I put the name PageTotal. But i
get an empty field.What should I put on the control source?
 
The Control Source of the PageTotal text box is left blank.

It is the code in the Format event procedure of the Page Footer section that
assigns it a value.
 
In your link, you say "In the Code Window under Declarations enter:", can you
explain "Code Window" and "Declarations" please?
 
Back
Top