Help with access report page numbering 2

[Tootle]

The situation is as follows
I have a report generating delivery notes, one large report totaling maybee 300 pages. My problem is that i need to number the pages for each individual Delivery address ie maybee there are a total of 300 pages for 100 different addresses so each one might have 3 pages i would like the report to display page 1 of 3, page 2 of 3, page 3 of 3 and then start to renumber on the next address page 1 of 3 etc bearing in mind that some may be 3 pages long others may be 10 there is no set limit.
I hope i have explained this ok

Thanks in advance

Andy

 

[KenReay]

hi

See

http://www.mvps.org/access/reports/rpt0013.htm

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[Tootle]

Thanks KenReay

Havent got it to work yet, for some reason and i cant see why within the code as everything seems as it should be im sure with a little time on it i will sus why.It seems to be just what i need.


Thanks
Andy

 

[CosmoKramer]

Another option:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q104760

 

[LisaWay]

I couldn't get the first suggestion (

http://www.mvps.org/access/reports/rpt0013.htm)

to work either until I put a control in the page footer that had

="Page " & [Page] & " of " & [Pages]

as the control source. (I marked the control's visible property = false.) Then everything worked perfectly. Thanks!