Stumped - Page Numbers in Header

G

Gina Whipp

All,

This one has me stumped...

I have created a report using tblCopy which is placed in the reports Page
Header. Now I would like to print page numbers in the report header on that
report, see below. (If I was using a group this would be a no brainer.)
What I am getting is 1 of 4, which is TECHNICALLY correct but not what I
want.

rptABC- Master
1 of 2
2 of 2

rptABC - Copy
1 of 2
2 of 2

The above is one print job. Any thoughts how I can accomplish in the Page
Header?
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm
 
S

strive4peace

Hi Gina,

will you always have just a Master and a Copy? so, whatever the page
count, you want exactly half the page count for the total pages?

how are you generating the copy? With a table of numbers? or are you
specifying copies = 2?

Please explain a bit more about how the Recordset is determined, thank you


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 
G

Gina Whipp

Crystal,

First of all, I am honored...

Yes I will always have a Master and a Copy:

tblCopy
cCopy (2 records = Master:Copy, because they also want that to show on the
report)

It is dropped in the query, no join, which runs the report, just the field
cCopy.

Yes, I will alyas have half page count for total of pages. The only thing
is I won't know total of pages because these are Contracts. Could be 1 page
(which would be 2 pages : Master:1 Copy), could be 10 pages (which would be
10 pages Master: 10 pages Copy).

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm
 
B

Bob Quintal

Crystal,

First of all, I am honored...

Yes I will always have a Master and a Copy:

tblCopy
cCopy (2 records = Master:Copy, because they also want that to
show on the report)

It is dropped in the query, no join, which runs the report, just
the field cCopy.

Yes, I will alyas have half page count for total of pages. The
only thing is I won't know total of pages because these are
Contracts. Could be 1 page (which would be 2 pages : Master:1
Copy), could be 10 pages (which would be 10 pages Master: 10 pages
Copy).
Click to expand...
I'd set visible=false for the existing page and pages controls
I'd add new controls with pages/2 for the total and
iif(page>total/2,page-total/2,page) for the actual page number.
 
G

Gina Whipp

Okay, good tell me how? If you do it all the time this should be a no
brainer for you!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

I do this in SQL Server Reporting Services _ALL_ time time.
 
G

Gina Whipp

I know but I couldn't resist... especially, as I don't expect he knows how
or he would have shared that with group to show his superiority!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm
 
S

strive4peace

Hi Gina,

thank you for your kind words -- would have said something earlier, but
I saw that Bob gave you a good idea :)

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restarting Page Numbers on a Multi-Page Report 3
Page header in subreport does'nt repeat 1
Page Header problem 2
Report Header! 1
Page header problem 1
page header on second page of invoice. 3
"Continued" in Header and Repeat Footers 1
sum of calculated fields in header of report 1

Top