Grouping Page Numbers

  • Thread starter Thread starter Mark G.
  • Start date Start date
M

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?
 
Mark said:
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?
Click to expand...


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.
 
Where is the group header format event, I can't seem to
find that? Is that the same as the foot header?
 
Mark said:
Where is the group header format event, I can't seem to
find that? Is that the same as the foot header?
Click to expand...

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]


 
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-----
Mark said:
Where is the group header format event, I can't seem to
find that? Is that the same as the foot header?
Click to expand...

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]



.
Click to expand...
 
Back
Top