Total in page footer

[Guest]

I have a report with many clients and their expenses of the month, but some
of them have 2 or 3 pages of expenses, what im trying to do is this:

Page 1
Page Footer
Sub-Total 1 (sum of all expenses in this page) Total 1(page 1 is the same
value as Sub-Total)

Page 2
Page Footer
Sub-Total 2 (sum of all expenses in this page) Total (Sub-Total 1 +
Sub-Total 2)

Page 3
.....
.....

When it moves to another client the sub-total and total should reset to 0
(zero)

Is this possible?

Thanks
PC

 

[Larry Linson]

Sum and Count functions work nicely, as you'd expect them to, in Group and
Report footers, but they don't play well with Page Footers. You'll probably
have to jump though some hoops with an invisible control with the Running
Sum property set, and a little math to subtract the value from the previous
page.

Larry Linson
Microsoft Access MVP