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.
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, place the field cCopy in the Report Header and run the Report.  To download the sample click here.
The difficult I do immediately, the impossible takes a little bit longer.
Reports
Tips (Main)
Home
Print Full or Partial Sheet of Same Labels
Print One or More Labels for One or More Clients (Records)
Keep Main Report/Subreport Records Together
Multicolumn Report with Images
Filtering Reports
Click to send feedback...
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.