Reset Page numbering in groups on a report

[Guest]

="Page " & [Page] & " of " & [Pages]
I need the [Pages] part of this to give me the total number of pages in the
group not the total for the whole report.

IE... 1 of 3, 2 of 3, 3 of 3 (for Group)

not 1 of 1033, 2 of 1033, 3 of 1033 (for whole Report)

I already have the reset working for the [Page] in the group

Any help or suggestions would be greatly appreciated

 

[Guest]

take a look at


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

 

[Guest]

Thanks, it worked for the most part. I did have to tweak one lines of the
code though.

Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer) -
as it is on the webpage

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As
Integer) - as it is for my use

take a look at


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

="Page " & [Page] & " of " & [Pages]
I need the [Pages] part of this to give me the total number of pages in the
group not the total for the whole report.

IE... 1 of 3, 2 of 3, 3 of 3 (for Group)

not 1 of 1033, 2 of 1033, 3 of 1033 (for whole Report)

I already have the reset working for the [Page] in the group

Any help or suggestions would be greatly appreciated