Printing page number & showing detail header on each page

  • Thread starter Thread starter Bethany P via AccessMonster.com
  • Start date Start date
B

Bethany P via AccessMonster.com

I have created one report from a fairly simple table called
commission_details. The report is grouped by vendor number and the goal is to
essentially create a separate statement for each vendor. I've got the group
header set up so it works properly, showing at the beginning of each group.
In the footer of each page I want to show Page N of M, where M is the total
number of pages for the particular group rather than the number of pages for
the entire report. I know there has to be a fairly simple way to do this,
but I have been unable to figure it out. I have figured out how to reset the
page number so it starts with one on each vendor change, now I just need the
latter part of the equation solved.
My second question is surrounding a header row for the detail. I would like
the column lables for the detail section to show on every page of the report,
rather than just on the first page. I've tried a few different ways to get
it to work but nothing seems to do the trick.
Help on either of these problems would be appreciated greatly!
Thank you,
Bethany Perkins
 
I have created one report from a fairly simple table called
commission_details. The report is grouped by vendor number and the goal is to
essentially create a separate statement for each vendor. I've got the group
header set up so it works properly, showing at the beginning of each group.
In the footer of each page I want to show Page N of M, where M is the total
number of pages for the particular group rather than the number of pages for
the entire report. I know there has to be a fairly simple way to do this,
but I have been unable to figure it out. I have figured out how to reset the
page number so it starts with one on each vendor change, now I just need the
latter part of the equation solved.
My second question is surrounding a header row for the detail. I would like
the column lables for the detail section to show on every page of the report,
rather than just on the first page. I've tried a few different ways to get
it to work but nothing seems to do the trick.
Help on either of these problems would be appreciated greatly!
Thank you,
Bethany Perkins
Click to expand...

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]
 
Back
Top