The difficult I do immediately, the impossible takes a little bit longer.
This sample database will allow you to run two copies of one report. This database requires Access 2003 or above...
Multiple copies of 1(one) Report using a Cartesian Product...
You want to print out a report but you want two copies because one needs to say *Original* and the other you want to say *Copy*. (Note: you can make your copies say anything you want and you are not limited to two.
The only thing you need to add to your database is tblCopy with one field, cCopy. Once you have created the table drop it in the query that is the RecordSource of the Report.
Note: Using this type of query you can only use INNER joins. The Cartesian join (or rather lack there of) does not support RIGHT or LEFT joins.
Note: If you are using Headers and/or Footers in your report make sure the cCopy is first or you will not get multiple copies.
Next, drop the field cCopy in the Header and run...