Subtotal by page

[ldbarh]

I'm sure this is easy but I can't seem to wrap my mind around it.

Problem= need to print list of jobs with invoice amounts and subtotal by page. could be as many as120 records only one field to total "amount" currently prints total for all founrd records at bottom of all pages need page totals and then total amount for all pages.

[BobWeaver]

1. Create a global number field called gRecordsPerPage.

2. Create an unstored calculation field called cPageNo with this formula:

Int((Status(CurrentRecordNumber)-1)/gRecordsPerPage)

3. Put a trailing subsummary part (sorted by cPageNo) at the bottom of your page layout. Set it to page break after every 1 occurence. Put your page total summary fields in this part.

4. Figure how many records will fit on a page and set gRecordsPerPage to this value.

5. Sort by cPageNo.

6. Print.

I would have answered your post sooner, but I didn't really think this would work. So, I had to try it first. Seems OK.

[ldbarh]

Thanx I'll try it out this weekend.

[ldbarh]

couldn't wait, it worked great, thank you!!!