Page Numbering

[alison.justice]

I have a report that when it I run it it will pull up different customer's,
how can I get the page numbering to re-number(start over) when the page comes
to a different customer?

 

[BruceM]

If you group by customer you can use code to restart the page numbering for
each customer:
http://www.mvps.org/access/reports/rpt0013.htm

For reasons I do not recall I think it is necessary to put an unbound
(hidden, if you like) text box in the group footer with the ControlSource
set to =[Pages]. This is in addition to the method described in the link.

 

[alison.justice]

Thank you for the help I'll try it.

--
Alison

[Pages] (hiden or not) any where in a report causes the Format event to fire
twice; the first time to get the number of pages and the second time to
format the report before printing.

Steve
(e-mail address removed)

If you group by customer you can use code to restart the page numbering
for each customer:
http://www.mvps.org/access/reports/rpt0013.htm

For reasons I do not recall I think it is necessary to put an unbound
(hidden, if you like) text box in the group footer with the ControlSource
set to =[Pages]. This is in addition to the method described in the link.

I have a report that when it I run it it will pull up different
customer's,
how can I get the page numbering to re-number(start over) when the page
comes
to a different customer?