Page Numbers

I have a 2500 page report, without any subreports. On each page I have a store number. Whenever the store number changes I need to reset the page numbers so that each store can get a copy of the report with the proper number of page numbers.

EG:
Store 250 has 3 pages, so instead of reading 1353 of 2500, 1354 of 2500 and 1355 of 2500, it should actually read 1 of 3, 2 of 3 and 3 of 3.

Any help would be greatly appreciated.

Thanks,

Sparx

Article ID: Q104760

.