How to SubTotal a list page by page?

[CaelC]

For simplicity sake ... I have a database with two fields. Client and Amount.

I have a list of Clients and the amounts they owe. I want to print the list having a subtotal at the bottom of each page showing how much is owed on that page. The clients and amounts change every month.

I can't seem to get this to work with sub-summaries or summary fields. It's easy to total the whole thing but I can't seem to get it to understand that I only want a subtotal for each page.

In the actual application it has to be subtotaled on each page to meet a standard for a form submitted to the government otherwise there really isn't any reason to do this.

Thanks for any help,

Cael.

[BobWeaver]

There may be a neater way to do this, but...

If you know how many records will fit on a page, you could create a PageNo field, and using a script, sort the records the way you intend to print them, and then set the PageNo field in each record to the page that it will appear on. Eg., if you have 30 records per page, set the value for the first 30 records to 1, the next 30 records to 2, and so on. Then, on your print layout, place a sub-summary part based on PageNo, with page break after every occurence. Put your Total summary field in this part. Now, add the PageNo field to the top of your sort order. Sort. Print.

This may or may not work well depending on what other sub-summary parts you have on your layout.