print double address labels

B

babcidziadziu

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.
 
D

Duane Hookom

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.
 
P

PC Datasheet

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.
 
J

John Spencer (MVP)

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.
 
Top