Duplicate Labels

[CB61]

..I am using avery labels#5392 6 to a page and need to make duplicate name
badges running horizontally across the page so there are 3 sets of badges per
page, the label report runs from a query, any help is appreciated

 

[Allen Browne]

Create a simple little table with one field named ID, type Number.
Mark the field as primary key.
Save the table with a name such as tblCount.
Enter 3 rows (the numbers 1 to 3.)

Open your query, add add this table.
Do not join it to your existing table (i.e. the 2 tables in the upper pane
of query design are unjoined.) You will now get 3 of each label for your
report.

 

[CB61]

Allen thank you so much I can't believe how easy that was! this discussion
group is wonderful.

 

[i_takeuti]

.I am using avery labels#5392 6 to a page and need to make duplicate name
badges running horizontally across the page so there are 3 sets of badges
per
page, the label report runs from a query, any help is appreciated