Total of items in each page in a report

[Mansoor]

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]

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.

 

[Mansoor]

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.

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?

 

[Allen Browne]

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.

 

[Mansoor]

Now it works perfectly.
THANK YOU VERY MUCH
Mansoor

 

[Ken R]

In your link, you say "In the Code Window under Declarations enter:", can you
explain "Code Window" and "Declarations" please?