Page numbering as function of grouping in a report

[Simon]

Dear reader,

Most of the reports have a page numbering as Page x of nn, starting at the
first page 1 (one) to the last page nn.

But know I need to start with Page 1 of nn for each report-group.

Is there code available to reset the page numbering for each group in a
report.,

and which event is the trigger for that code.

Tanks for any help.

Kind regard,

Simon van Beek

[fredg]

On Sun, 5 Feb 2006 18:32:02 +0100, Simon wrote:

Dear reader,

Most of the reports have a page numbering as Page x of nn, starting at the
first page 1 (one) to the last page nn.

But know I need to start with Page 1 of nn for each report-group.

Is there code available to reset the page numbering for each group in a
report.,

and which event is the trigger for that code.

Tanks for any help.

Kind regard,

Simon van Beek

See:
"Printing First and Last Page Numbers for Report Groups "
http://www.mvps.org/access/reports/rpt0013.htm

Things to make sure of:
1) Add a control to the page Footer that computes [Pages],
i.e. = [Pages]
You can make this control not visible if you wish.

2) Add an unbound control to the Page Footer.
Name this control "ctlGrpPages"

3) Paste the code into the Page Footer Format event.

4) In the code, change Me!Salesman to
Me![Name of the control used to group by]
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail