Page Numbering in Access Reports

[Ajay]

I have designed a database for printing statements where the Account_Num is
primary key.I am using subreports to populate the detail section of the
report.
When there is more data the page changes but with the same header ie; the
Account_Num. The reports print fine but I dont seem to get the paging logic.
The page number should be 1 when the Account_Num changes and it should read
Page 1 of 2 for example. Any ideas on this issue is appreciated

 

[bcap]

Access only supports page numbering across the report as a whole.

If you group the report on Account_Num, then you can force what you want to
achieve with a certain amount of work Here's one way of doing it:

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