Page Numbers

[sparx]

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

 

[Newman]

take a look at this post:
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=38244
Newman

 

[sparx]

Unknown variable

In the for loop you refer to the variable 'NumberOfCustomers', where does this come from as it is never declared nor initialized in the sample code given