Print Report twice

  • Thread starter Thread starter yiotaa
  • Start date Start date
Y

yiotaa

I have a report and i want to print it twice but in the 2nd copy i also want
to the header of the report to be added the word "REMINDER".
 
yiotaa said:
I have a report and i want to print it twice but in the 2nd copy i also
want
to the header of the report to be added the word "REMINDER".
Click to expand...

Use a Cartesian Product query to give you 2 copies of each record for your
report.

Steps:

1. Create a little table with 2 fields like this:
- CopyID Number primary key
- CopyName Text

2. Enter 2 rows. Leave CopyName blank for #1, and enter 'REMINDER' for #2.

3. Create a query using this table as well as your existing one. There
should be no line joining the 2 tables in the upper pane of query design.
This gives you 2 of every record: copy 1 (with CopyName blank), and copy 2
(with CopyName shown as 'reminder.')

4. Change the RecordSource property of your report to this new query.

5. In the report's Sorting'n'Grouping box, sort by CopyID. If desired, make
it a group header, and set its properties so each copy starts on a new page.

6. Add the CopyName field where you want the word 'REMINDER' to show.
 
Back
Top