Forum Discussion
Labels on Access Report
I have a report that prints 4x2 labels, but when I request multiple copies of the records, they are printed on different pages instead of being consolidated on the same page. This leads to wasted labels. How can I fix this issue?
If your report is already setup to use the labels correctly, you can multiply your records with a Cross Join. Let's say you want 3 copies of each address. You could write in the RecordSource:
Select * From query_with_addresses, (Select Top 3 '' As EmptyField From some_table_with_a_least_3_rows);
Try grouped report or subreport as below:
- Create a New Report: Open Access and create a new report.
- Add Subreports: Instead of printing multiple copies directly, add the original report as a subreport within the new report. This way, you can control the layout and ensure all copies are on the same page.
- Grouping: If you prefer not to use subreports, you can create a grouped report. Group the records by the field that determines the copies needed, and then place the report content in the group header or detail sections.
