Page numbering-need first page number to be >1

  • Thread starter Thread starter jennifer
  • Start date Start date
J

jennifer

Making the descent into Access. Not enjoying it much.
I need to do a report, and I need the first page number
to be 8 or 9 instead of 1. I know how to get the page
numbers to appear, but how do I get them to start with a
number greater than 1?
 
Making the descent into Access. Not enjoying it much.
I need to do a report, and I need the first page number
to be 8 or 9 instead of 1. I know how to get the page
numbers to appear, but how do I get them to start with a
number greater than 1?

Code the Report's Report Header Format event:
[Page] = [Page] + 7

Or ...

You could also simply use an unbound control.
Set It's Control Source to:
=[Page] + 7
 
Jennifer,

I feel your pain, Access sometimes is hard because things
are not clear. To fix your problem, if you know what you
want the page number to start with, you can add the
number the page by doing this:

="Page " & [Page]+7 & " of " & [Pages]

"Page 8 of ## (# of pages in the report)" appears on the
firt page. You may have to add the number to "Pages" as
well.

Good luck with Access.
Dallas Miller
 
GAWD that's so EASY and logical. guess that's why i'd
never think of it.
THANK YOU A ZILLION !!!!!!!
-----Original Message-----
Jennifer,

I feel your pain, Access sometimes is hard because things
are not clear. To fix your problem, if you know what you
want the page number to start with, you can add the
number the page by doing this:

="Page " & [Page]+7 & " of " & [Pages]

"Page 8 of ## (# of pages in the report)" appears on the
firt page. You may have to add the number to "Pages" as
well.

Good luck with Access.
Dallas Miller
-----Original Message-----
Making the descent into Access. Not enjoying it much.
I need to do a report, and I need the first page number
to be 8 or 9 instead of 1. I know how to get the page
numbers to appear, but how do I get them to start with a
number greater than 1?
.
.
 
a big thanks to Dallas & Fred. I appreciate the help
-----Original Message-----
Making the descent into Access. Not enjoying it much.
I need to do a report, and I need the first page number
to be 8 or 9 instead of 1. I know how to get the page
numbers to appear, but how do I get them to start with a
number greater than 1?

Code the Report's Report Header Format event:
[Page] = [Page] + 7

Or ...

You could also simply use an unbound control.
Set It's Control Source to:
=[Page] + 7

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
 
Back
Top