multiple labels of the same entry in order

[Larry]

We have created labels based on a query of 1000 different
entries. We want 7 copies of each entry's label, and we
need them in order. We don't want to have to print out 7
full copies of all 1,000 entries and go back through each
batch to match them. i.e., we need 7 address labels for
John Doe followed by 7 address labels for Jane Doe, etc.
in order on the label sheet. How do we tell the label
report to do this?
Thanks for your help!

 

[Rick Brandt]

We have created labels based on a query of 1000 different
entries. We want 7 copies of each entry's label, and we
need them in order. We don't want to have to print out 7
full copies of all 1,000 entries and go back through each
batch to match them. i.e., we need 7 address labels for
John Doe followed by 7 address labels for Jane Doe, etc.
in order on the label sheet. How do we tell the label
report to do this?
Thanks for your help!

Create a dummy table with 7 records in it (only needs one field). Add that table to
the query driving your report and do NOT add a join line. All of the output from
your current query will be duplicated 7 times (or as many records as you put in the
dummy table).