Page Nubmers

[ielmrani via AccessMonster.com]

Hi all,
I have no clue on how to do this. I need help please.

I have a report that I am trying to add numbers of pages to.

the report looks like this:

Hosital Name: New York Hospital

MemberName MemberID Codes
John 1111 C
T
F

Bob 2222 M
C
T
etc...

this report is sorted by Hospital Name. At the end of each page I want to
add the page number, but I only want to show the numbers of the pages for
each hospital. In other words, if New york Hospital has 4 pages then i need
to see on page1: page 1 of 4 and page2: 2 of 4 etc.... If a new hospital
name shows but have (let 's say 2 pages) then i need to see the name of the
hospital and on page1: page 1 of 2 and page2: 2 of 2.

I hope my question is clear. Thanks in advance

Ismail

 

[fredg]

Hi all,
I have no clue on how to do this. I need help please.

I have a report that I am trying to add numbers of pages to.

the report looks like this:

Hosital Name: New York Hospital

MemberName MemberID Codes
John 1111 C
T
F

Bob 2222 M
C
T
etc...

this report is sorted by Hospital Name. At the end of each page I want to
add the page number, but I only want to show the numbers of the pages for
each hospital. In other words, if New york Hospital has 4 pages then i need
to see on page1: page 1 of 4 and page2: 2 of 4 etc.... If a new hospital
name shows but have (let 's say 2 pages) then i need to see the name of the
hospital and on page1: page 1 of 2 and page2: 2 of 2.

I hope my question is clear. Thanks in advance

Ismail

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]

 

[ielmrani via AccessMonster.com]

Hi,
thanks for your reply.

I did not work for. I am not sure what I did wrong.
I created a new control and named it "ctlGrpPages"

I pasted the code into the Page Footer Format event.
I also changed the name Me!Salesman to group by name.
but nothing is showing.
any idea.

Hi all,
I have no clue on how to do this. I need help please.

[quoted text clipped - 25 lines]

Ismail

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]

 

[ielmrani via AccessMonster.com]

Worked. My fault, I used the wrong Group by name.

Again Thanks for your help

Hi,
thanks for your reply.

I did not work for. I am not sure what I did wrong.
I created a new control and named it "ctlGrpPages"

I pasted the code into the Page Footer Format event.
I also changed the name Me!Salesman to group by name.
but nothing is showing.
any idea.
Ismail[quoted text clipped - 18 lines]

4) In the code, change Me!Salesman to
Me![Name of the control used to group by]