Duplicate records for label

G

Guest

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.
 

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

Similar Threads

MS Access 2007 Dot Matrix Label Printing 0
repeat a copy of a report based on a parameter 1
creating a label report in access 27
Label alignment????? 8
labels with group header, detail, group footer sections 7
Page Setup with VBA 1
how to modify the type of label a report is using 3
Setting up a report for a DYMO labeller 1

Top