Grouping Page Numbers

[Mark G.]

I have a report that sorts by Officer and it is all in one
report and what I am trying to do is group the page
numbers to the number of pages for each officer. So it
would look like Loan Officer Bates (page 1, 2, 3) then
Loan Officer Adams (page 1, 2, 3) instead of it just going
(page 1,2,3,4,5,6). Is there anyway that I can have the
page numbers group to the loan officer?

 

[Marshall Barton]

I have a report that sorts by Officer and it is all in one
report and what I am trying to do is group the page
numbers to the number of pages for each officer. So it
would look like Loan Officer Bates (page 1, 2, 3) then
Loan Officer Adams (page 1, 2, 3) instead of it just going
(page 1,2,3,4,5,6). Is there anyway that I can have the
page numbers group to the loan officer?

You can reset the report's Page property to 1 as needed.

If you are printing the page numbers in the page footer,
then reset the page number in the group header's Format
event. If you have the page numbers in the page header,
then reset it in the group footer.

 

[Mark G.]

Where is the group header format event, I can't seem to
find that? Is that the same as the foot header?

 

[Marshall Barton]

Where is the group header format event, I can't seem to
find that? Is that the same as the foot header?

You are using grouping in the Sorting and Grouping window to
specify a grouping field along with a group header and/or
footer sections.

Once you locate the proper section in the report design,
click on the [...] button at the far right of the OnFormat
property in the section's property sheet. This will take
you to the section's Format event procedure where you can
enter the line of code:
Me.Page = 1
--
Marsh
MVP [MS Access]

 

[Guest]

Thank you, so very very much we appreciate all your help.
I was losing sleep over this darn thing and now I can
finally get a good night sleep.

-----Original Message-----

Where is the group header format event, I can't seem to
find that? Is that the same as the foot header?

You are using grouping in the Sorting and Grouping window to
specify a grouping field along with a group header and/or
footer sections.

Once you locate the proper section in the report design,
click on the [...] button at the far right of the OnFormat
property in the section's property sheet. This will take
you to the section's Format event procedure where you can
enter the line of code:
Me.Page = 1
--
Marsh
MVP [MS Access]



.