print double address labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i know how to print address labels in access.. i would like to know if it is
possible to print a double of all these addresses at the same time.
 
A simple, no code method is to create a table of numbers "tblNums" with a
single numeric field "Num" and add two records with values 1 and 2.

Add this table to your report's recordsource and don't create any join
lines. This will create a copy of each record.
 
Create a query that returns all the data for your labels. Union the query to
itself and you will get two labels for each record.
 
This would work as long as you used the UNION ALL conjunction and not the UNION conjunction.

That said, Duane Hookom's solution is better, especially if someone decides they
want three or four or two copies. That solution allows you to specify the
number of copies by using criteria to limit the number of copies returned.
 
Back
Top