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 lab...
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);