page numbering

[jean.ulrich]

Hi

I have a query issued from 2 tables

First table contain 300 records (each record have a different ID)
Second table contain 1400 records so a lot of records have the same ID
That produce a report of around 380 pages as the same ID can produce
one page or 2 or 3 or 5 ....
When I insert page numbering at the bottom of the report it give me
page 1 of 380, page 2 of 380, page 3 of 380 and so on .....
What I would like to have is that
If an ID produce 1 page, numbering should be page 1 of 1
If an ID produce 4 pages, i would like page 1 of 4, page 2 of 4, page
3 of 4 and page 4 of 4
If and ID produce 2 pages, I would have page 1 of 2 and page 2 of 2
And of course I would like to print all the 380 pages within one mouse
click

thanks

 

[fredg]

Hi

I have a query issued from 2 tables

First table contain 300 records (each record have a different ID)
Second table contain 1400 records so a lot of records have the same ID
That produce a report of around 380 pages as the same ID can produce
one page or 2 or 3 or 5 ....
When I insert page numbering at the bottom of the report it give me
page 1 of 380, page 2 of 380, page 3 of 380 and so on .....
What I would like to have is that
If an ID produce 1 page, numbering should be page 1 of 1
If an ID produce 4 pages, i would like page 1 of 4, page 2 of 4, page
3 of 4 and page 4 of 4
If and ID produce 2 pages, I would have page 1 of 2 and page 2 of 2
And of course I would like to print all the 380 pages within one mouse
click

thanks

Group the report on the ID field.
In Report Design view, click on
View + Sorting and Grouping
Enter the ID field in the Field/Expression column.
In the lower panel, set GroupHeader to Yes.
Exit the dialog.
Then, set the GroupHeader ForceNewPage property (it's on the Format
page of the property sheet) to BeforeSection (so each new ID group
will start a new page).

Then 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]
= [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]

 

[BruceM]

Group the report by the ID, and use the code found in the attached link to
number within the group.
http://www.mvps.org/access/reports/rpt0013.htm

 

[i_takeuti]

Hi

I have a query issued from 2 tables

First table contain 300 records (each record have a different ID)
Second table contain 1400 records so a lot of records have the same ID
That produce a report of around 380 pages as the same ID can produce
one page or 2 or 3 or 5 ....
When I insert page numbering at the bottom of the report it give me
page 1 of 380, page 2 of 380, page 3 of 380 and so on .....
What I would like to have is that
If an ID produce 1 page, numbering should be page 1 of 1
If an ID produce 4 pages, i would like page 1 of 4, page 2 of 4, page
3 of 4 and page 4 of 4
If and ID produce 2 pages, I would have page 1 of 2 and page 2 of 2
And of course I would like to print all the 380 pages within one mouse
click

thanks