How do I print a page of the same address label on Avery L7161 lab

G

Guest

I'm able to print individual labels and sheets of different address labels
from my database, but cannot figure out how to print a whole sheet of the
same address label. Can anyone advise me?
 
D

Duane Hookom

Create a table of numbers (tblNumbers) with a single, numeric field (Num)
and add records for values 1 .... your highest quantity. Add this table to
your report's record source and don't join it. Add the Num field to the grid
and set a criteria of something like:
<=30
This should produce 30 copies of the same record.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top