Page numbering as function of grouping in a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon - 05 Feb 2006 17:32 GMT

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

Reply to this Message

fredg - 05 Feb 2006 17:48 GMT

> Dear reader,
>
[quoted text clipped - 13 lines]
>
> 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]

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message