Report Problem

H

Hansford cornett

I have a paper pre-printed form I am trying to duplicate in a Access 2000
report.
The paper document has 2 sides withe the front being filled in the first
mailing and the back for the second mailling. The front and back must both
print in duplex mode for both mailings.

I have a header poriton and footer portion and a subform that prints 2
columns per page. It is located in the detail section and prints the front
pages ok. When I have 4 records it prints the first two and goes on to the
next page and prints the next two. If the record number is odd it prints
only 1 record on the last page.

I need two records per page and need to print a blank area with lines if the
nr records is odd.

I need to print the back page of the form when the 2 records in columns is
printed on the front of the page so when the document is printed in duplex
mode it will print the back of the form properly.

HELP. I have tried eliminating the header and footer and just placing them
on a page and then adding a page break however nothing allows the first page
to create a second page for the back before printing the next 2 records for
page 2's FRONT....

HELP HELP HELP!
 
Top