Printing in Access

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

Guest

This is an odd question . . .

I created a report to print labels for mailing.
But I need the addresses to be duplicated 5 times.
The information is in the database only once, though.

I know I can print 5 copies, but that means I'd use up 5 seperate pages of
labels.

Can I tell Access to print the address 5 times in succession on the same page?

I hope this question makes sense.
 
Create a union query that repeats the union 5 times and use it as the basis
for your label report:

Select Name, Address, City & ", " & State & " " & Zipcode As CityStateZip
From YourTable
Union All
Select Name, Address, City & ", " & State & " " & Zipcode As CityStateZip
From YourTable
Union All
Select Name, Address, City & ", " & State & " " & Zipcode As CityStateZip
From YourTable
Union All
Select Name, Address, City & ", " & State & " " & Zipcode As CityStateZip
From YourTable
Union All
Select Name, Address, City & ", " & State & " " & Zipcode As CityStateZip
From YourTable
Order by Some Field;
 
Pam Besteder said:
This is an odd question . . .

I created a report to print labels for mailing.
But I need the addresses to be duplicated 5 times.
The information is in the database only once, though.

I know I can print 5 copies, but that means I'd use up 5 seperate pages of
labels.

Can I tell Access to print the address 5 times in succession on the same page?
Click to expand...


Sure it makes sense.

One way to do this that can easily be adapted to any number
of copies is to create a table named Numbers with one field
named NumCopies. Populate the table with the numbers 1, 2,
3, ... up to the most you could ever want.

Then use a query as the label report's record source:

SELECT table.*, Numbers.NumCopies
FROM table, Numbers
WHERE Numbers.NumCopies <= 5

You can even put the label's copy number on the label if you
want.
 
Back
Top