page numbering

[Guest]

I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages). I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that point. I can get the
report to start from page 1 easy enough, but starting from any other page
appears to be a challenge.

There must be an easy way to do this.

Thanks.

 

[Marshall Barton]

I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages). I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that point. I can get the
report to start from page 1 easy enough, but starting from any other page
appears to be a challenge.

Set the page number text box's expression to:
=Page + 40

 

[Guest]

Thanks Marsh, I appreciate your response. Let me throw in one further
wrinkle. Let's say I wanted to number pages 41-65 skip the sequential page
66 and renumber the following page (what would have been page 67) as page 66
and proceed sequentially from there. How would I set that up?

A second related question, In addition to skipping pages in numbering can I
also skip those pages in printing?

I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages). I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that point. I can get the
report to start from page 1 easy enough, but starting from any other page
appears to be a challenge.

Set the page number text box's expression to:
=Page + 40

 

[Marshall Barton]

There are two approaches you can use to deal with this
issue. Usually, the easiest is to use an expression similar
to what is posted before. If you don't need to leave more
than a couple of different gaps in the page numbering, use a
conditional function in the text box expression:

=Page + 40 + IIf(Page>=16, 1,0) + IIf(Page>=82, 3,0)
or
=Page + Switch(Page<16,40, Page<123,41, True,44)

The other approach is to manipulate the actual value of the
Page property in an event procedure (probably the Page
header section's Format event).

Select Case Me.Page
Case 1
Me.Page = 41
Case 66
Me.Page = Me.Page + 1
End Select

Neither approach will leave any blank pages.
--
Marsh
MVP [MS Access]

Thanks Marsh, I appreciate your response. Let me throw in one further
wrinkle. Let's say I wanted to number pages 41-65 skip the sequential page
66 and renumber the following page (what would have been page 67) as page 66
and proceed sequentially from there. How would I set that up?

A second related question, In addition to skipping pages in numbering can I
also skip those pages in printing?

I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages). I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that point. I can get the
report to start from page 1 easy enough, but starting from any other page
appears to be a challenge.

Set the page number text box's expression to:
=Page + 40

 

[Guest]

Thanks again Marsh, for your quick reply. As you mentioned, this does leave
gaps in the page numbering but that was what I was trying to avoid. I simply
wanted to exclude certain pages altogether and number the report around those
excluded pages (as if they didn't exist).

There are two approaches you can use to deal with this
issue. Usually, the easiest is to use an expression similar
to what is posted before. If you don't need to leave more
than a couple of different gaps in the page numbering, use a
conditional function in the text box expression:

=Page + 40 + IIf(Page>=16, 1,0) + IIf(Page>=82, 3,0)
or
=Page + Switch(Page<16,40, Page<123,41, True,44)

The other approach is to manipulate the actual value of the
Page property in an event procedure (probably the Page
header section's Format event).

Select Case Me.Page
Case 1
Me.Page = 41
Case 66
Me.Page = Me.Page + 1
End Select

Neither approach will leave any blank pages.
--
Marsh
MVP [MS Access]

Thanks Marsh, I appreciate your response. Let me throw in one further
wrinkle. Let's say I wanted to number pages 41-65 skip the sequential page
66 and renumber the following page (what would have been page 67) as page 66
and proceed sequentially from there. How would I set that up?

A second related question, In addition to skipping pages in numbering can I
also skip those pages in printing?

Accessguy wrote:
I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages). I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that point. I can get the
report to start from page 1 easy enough, but starting from any other page
appears to be a challenge.

Set the page number text box's expression to:
=Page + 40

 

[Marshall Barton]

I think I'm lost here. Are you saying that you want to skip
printing some of the pages in the report? Kind of like
printing the entire report and then throwing away the pages
you didn't want???
--
Marsh
MVP [MS Access]

Thanks again Marsh, for your quick reply. As you mentioned, this does leave
gaps in the page numbering but that was what I was trying to avoid. I simply
wanted to exclude certain pages altogether and number the report around those
excluded pages (as if they didn't exist).

There are two approaches you can use to deal with this
issue. Usually, the easiest is to use an expression similar
to what is posted before. If you don't need to leave more
than a couple of different gaps in the page numbering, use a
conditional function in the text box expression:

=Page + 40 + IIf(Page>=16, 1,0) + IIf(Page>=82, 3,0)
or
=Page + Switch(Page<16,40, Page<123,41, True,44)

The other approach is to manipulate the actual value of the
Page property in an event procedure (probably the Page
header section's Format event).

Select Case Me.Page
Case 1
Me.Page = 41
Case 66
Me.Page = Me.Page + 1
End Select

Neither approach will leave any blank pages.

Thanks Marsh, I appreciate your response. Let me throw in one further
wrinkle. Let's say I wanted to number pages 41-65 skip the sequential page
66 and renumber the following page (what would have been page 67) as page 66
and proceed sequentially from there. How would I set that up?

A second related question, In addition to skipping pages in numbering can I
also skip those pages in printing?


Accessguy wrote:
I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages). I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that point. I can get the
report to start from page 1 easy enough, but starting from any other page
appears to be a challenge.

:
Set the page number text box's expression to:
=Page + 40

 

[Guest]

Exactly. We publish aggregated data for each program our students have
graduated from as part of an annual report we do. Each program appears on a
separate page of that report and includes, among other things, information
relating to attitudes, satisfaction, job status, employer and salary.
Although most of the information is very general, some of the data we
collect, however, are from programs that have very few students which, in
some cases could by default, reveal their identity and/or selected personal
information (e.g. salary or employer). Since we have a policy of not
printing detailed program information for those programs graduating fewer
than 3 students, I do not wish to print these particular program sheets. I
can physically remove them easily enough when printed but obviously run into
problems with the numbering sequence. I do choose to keep this information
in the database for other aggregated tables that we do where this is not a
concern .

I think I'm lost here. Are you saying that you want to skip
printing some of the pages in the report? Kind of like
printing the entire report and then throwing away the pages
you didn't want???
--
Marsh
MVP [MS Access]

Thanks again Marsh, for your quick reply. As you mentioned, this does leave
gaps in the page numbering but that was what I was trying to avoid. I simply
wanted to exclude certain pages altogether and number the report around those
excluded pages (as if they didn't exist).

There are two approaches you can use to deal with this
issue. Usually, the easiest is to use an expression similar
to what is posted before. If you don't need to leave more
than a couple of different gaps in the page numbering, use a
conditional function in the text box expression:

=Page + 40 + IIf(Page>=16, 1,0) + IIf(Page>=82, 3,0)
or
=Page + Switch(Page<16,40, Page<123,41, True,44)

The other approach is to manipulate the actual value of the
Page property in an event procedure (probably the Page
header section's Format event).

Select Case Me.Page
Case 1
Me.Page = 41
Case 66
Me.Page = Me.Page + 1
End Select

Neither approach will leave any blank pages.


Accessguy wrote:
Thanks Marsh, I appreciate your response. Let me throw in one further
wrinkle. Let's say I wanted to number pages 41-65 skip the sequential page
66 and renumber the following page (what would have been page 67) as page 66
and proceed sequentially from there. How would I set that up?

A second related question, In addition to skipping pages in numbering can I
also skip those pages in printing?


Accessguy wrote:
I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages). I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that point. I can get the
report to start from page 1 easy enough, but starting from any other page
appears to be a challenge.

:
Set the page number text box's expression to:
=Page + 40

 

[Guest]

As I am thinking about it, may I should be creating a separate file that
filters out these "low cases" out beforehand before I run the Access report
in the first place.

I think I'm lost here. Are you saying that you want to skip
printing some of the pages in the report? Kind of like
printing the entire report and then throwing away the pages
you didn't want???
--
Marsh
MVP [MS Access]

Thanks again Marsh, for your quick reply. As you mentioned, this does leave
gaps in the page numbering but that was what I was trying to avoid. I simply
wanted to exclude certain pages altogether and number the report around those
excluded pages (as if they didn't exist).

There are two approaches you can use to deal with this
issue. Usually, the easiest is to use an expression similar
to what is posted before. If you don't need to leave more
than a couple of different gaps in the page numbering, use a
conditional function in the text box expression:

=Page + 40 + IIf(Page>=16, 1,0) + IIf(Page>=82, 3,0)
or
=Page + Switch(Page<16,40, Page<123,41, True,44)

The other approach is to manipulate the actual value of the
Page property in an event procedure (probably the Page
header section's Format event).

Select Case Me.Page
Case 1
Me.Page = 41
Case 66
Me.Page = Me.Page + 1
End Select

Neither approach will leave any blank pages.


Accessguy wrote:
Thanks Marsh, I appreciate your response. Let me throw in one further
wrinkle. Let's say I wanted to number pages 41-65 skip the sequential page
66 and renumber the following page (what would have been page 67) as page 66
and proceed sequentially from there. How would I set that up?

A second related question, In addition to skipping pages in numbering can I
also skip those pages in printing?


Accessguy wrote:
I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages). I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that point. I can get the
report to start from page 1 easy enough, but starting from any other page
appears to be a challenge.

:
Set the page number text box's expression to:
=Page + 40

 

[Marshall Barton]

That would be the cleanest approach.

OTOH, maybe you can figure a way to just filter out the
private data for the low cases.
--
Marsh
MVP [MS Access]

As I am thinking about it, may I should be creating a separate file that
filters out these "low cases" out beforehand before I run the Access report
in the first place.

I think I'm lost here. Are you saying that you want to skip
printing some of the pages in the report? Kind of like
printing the entire report and then throwing away the pages
you didn't want???

Thanks again Marsh, for your quick reply. As you mentioned, this does leave
gaps in the page numbering but that was what I was trying to avoid. I simply
wanted to exclude certain pages altogether and number the report around those
excluded pages (as if they didn't exist).

:
There are two approaches you can use to deal with this
issue. Usually, the easiest is to use an expression similar
to what is posted before. If you don't need to leave more
than a couple of different gaps in the page numbering, use a
conditional function in the text box expression:

=Page + 40 + IIf(Page>=16, 1,0) + IIf(Page>=82, 3,0)
or
=Page + Switch(Page<16,40, Page<123,41, True,44)

The other approach is to manipulate the actual value of the
Page property in an event procedure (probably the Page
header section's Format event).

Select Case Me.Page
Case 1
Me.Page = 41
Case 66
Me.Page = Me.Page + 1
End Select

Neither approach will leave any blank pages.


Accessguy wrote:
Thanks Marsh, I appreciate your response. Let me throw in one further
wrinkle. Let's say I wanted to number pages 41-65 skip the sequential page
66 and renumber the following page (what would have been page 67) as page 66
and proceed sequentially from there. How would I set that up?

A second related question, In addition to skipping pages in numbering can I
also skip those pages in printing?


Accessguy wrote:
I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages). I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that point. I can get the
report to start from page 1 easy enough, but starting from any other page
appears to be a challenge.

:
Set the page number text box's expression to:
=Page + 40

 

[Guest]

Thanks Marsh, good suggestion. Sometimes talking these things out can reveal
things that are intuitively obvious. Have a nice Thanksgiving!

That would be the cleanest approach.

OTOH, maybe you can figure a way to just filter out the
private data for the low cases.
--
Marsh
MVP [MS Access]

As I am thinking about it, may I should be creating a separate file that
filters out these "low cases" out beforehand before I run the Access report
in the first place.

I think I'm lost here. Are you saying that you want to skip
printing some of the pages in the report? Kind of like
printing the entire report and then throwing away the pages
you didn't want???

Accessguy wrote:
Thanks again Marsh, for your quick reply. As you mentioned, this does leave
gaps in the page numbering but that was what I was trying to avoid. I simply
wanted to exclude certain pages altogether and number the report around those
excluded pages (as if they didn't exist).

:
There are two approaches you can use to deal with this
issue. Usually, the easiest is to use an expression similar
to what is posted before. If you don't need to leave more
than a couple of different gaps in the page numbering, use a
conditional function in the text box expression:

=Page + 40 + IIf(Page>=16, 1,0) + IIf(Page>=82, 3,0)
or
=Page + Switch(Page<16,40, Page<123,41, True,44)

The other approach is to manipulate the actual value of the
Page property in an event procedure (probably the Page
header section's Format event).

Select Case Me.Page
Case 1
Me.Page = 41
Case 66
Me.Page = Me.Page + 1
End Select

Neither approach will leave any blank pages.


Accessguy wrote:
Thanks Marsh, I appreciate your response. Let me throw in one further
wrinkle. Let's say I wanted to number pages 41-65 skip the sequential page
66 and renumber the following page (what would have been page 67) as page 66
and proceed sequentially from there. How would I set that up?

A second related question, In addition to skipping pages in numbering can I
also skip those pages in printing?


Accessguy wrote:
I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages). I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that point. I can get the
report to start from page 1 easy enough, but starting from any other page
appears to be a challenge.

:
Set the page number text box's expression to:
=Page + 40