Duplicate records for label

J

JMorrell

I have a query that feeds a label report. I want duplicate address labels.
How do I print duplicate labels with the 2nd label next to the first one,
rather than just printing a second set? Do I modify the query? If so, how?

tia,
 
D

Duane Hookom

You can add a table to your report's record source that returns 2 records.
Don't join it to any other table in your report's record source. This will
create to copies of each record in the query.

Many of us veterans keep a handy table of numbers tblNums with a single
numeric field [Num] and values 1 through some big number. We add the table
and set the criteria under [Num] to <=2.
 
Top