print every second page

[TerryC]

Hi,

I need to print every second page of a report and do not
know how to cancel the printing of selective pages.

I have a two page per record report and need to print page
1 on different stationary to page 2. I would like to
cancel the printing of even pages for one run and odd
pages on another run. Something like [Page] "If mod 2 = 0
then don't print" is what I would like.

Any suggestions on where and how to code this would be
greatly bappreciated.


TIA


Terry

 

[TerryC]

I meant:
If [Page] Mod 2 = 0 then don't print this page

Any suggestions really appreciated.

Terry

 

[Justin]

I would create two seperate reports.

I meant:
If [Page] Mod 2 = 0 then don't print this page

Any suggestions really appreciated.

Terry

-----Original Message-----
Hi,

I need to print every second page of a report and do not
know how to cancel the printing of selective pages.

I have a two page per record report and need to print page
1 on different stationary to page 2. I would like to
cancel the printing of even pages for one run and odd
pages on another run. Something like [Page] "If mod 2 = 0
then don't print" is what I would like.

Any suggestions on where and how to code this would be
greatly bappreciated.


TIA


Terry
.

 

[TerryC]

Justin,

Thanks for the response. I probably will have to make 2
reports. I was hoping to avoid this because of various
calculations and growing (shrinking) controls everywhere.
I also create individual PDF files from this report (2
page PDFs) so I suppose three reports and associated
maintenance ...... life wasn't meant to be easy ....


Thanks again

Terry

-----Original Message-----
I would create two seperate reports.

I meant:
If [Page] Mod 2 = 0 then don't print this page

Any suggestions really appreciated.

Terry

-----Original Message-----
Hi,

I need to print every second page of a report and do not
know how to cancel the printing of selective pages.

I have a two page per record report and need to print page
1 on different stationary to page 2. I would like to
cancel the printing of even pages for one run and odd
pages on another run. Something like [Page] "If mod 2 = 0
then don't print" is what I would like.

Any suggestions on where and how to code this would be
greatly bappreciated.


TIA


Terry
.

.

 

[fredg]

Hi,

I need to print every second page of a report and do not
know how to cancel the printing of selective pages.

I have a two page per record report and need to print page
1 on different stationary to page 2. I would like to
cancel the printing of even pages for one run and odd
pages on another run. Something like [Page] "If mod 2 = 0
then don't print" is what I would like.

Any suggestions on where and how to code this would be
greatly bappreciated.

TIA

Terry

Code EACH of the report section's Format event (PageHeader/Footer
Detail, Group Headers/Footers, etc.)

For Odd Page printout:
Cancel = Me.[Page] Mod 2 = 0

Then change the code for the Even pages:
Cancel = Me.[Page] Mod 2 = 1

Note: You will get a blank sheet of paper for each unprinted page.
You'll need to separate them out. Try it out on a small run before
venturing on a big report.

 

[TerryC]

Thanks Fred.

-----Original Message-----

Hi,

I need to print every second page of a report and do not
know how to cancel the printing of selective pages.

I have a two page per record report and need to print page
1 on different stationary to page 2. I would like to
cancel the printing of even pages for one run and odd
pages on another run. Something like [Page] "If mod 2 = 0
then don't print" is what I would like.

Any suggestions on where and how to code this would be
greatly bappreciated.

TIA

Terry

Code EACH of the report section's Format event (PageHeader/Footer
Detail, Group Headers/Footers, etc.)

For Odd Page printout:
Cancel = Me.[Page] Mod 2 = 0

Then change the code for the Even pages:
Cancel = Me.[Page] Mod 2 = 1

Note: You will get a blank sheet of paper for each unprinted page.
You'll need to separate them out. Try it out on a small run before
venturing on a big report.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.