1. Create a table with these fields:
ReportTypeID Number primary key
ReportTypeName Text
Save it with the name tblReportType.
Enter 3 records, e.g.:
1 Original
2 Client Copy
3 Office Copy
2. If you do not already have a query that feeds the report, create one.
Along with your existing table(s), add tblReportType. There must be *no*
line joining this table to your other ones. Save the query.
3. If you need to, open the report in design view, and set its RecordSource
property to the name of your query. You can also add a text box for the
ReportTypeName if you want to print that on the 3 copies.
This works because Access generates every possible combination if you do not
have a join between tables in your query. It therefore gives you 3 of each
record. It is still possible to filter this report to the appropriate copy
if you need to do that too.
