printing differing number of labels

[Ron DeGregorio]

I have a report that prints 1 label for each record in a query based on a
table. I would like to print different numbers of labels for different
records based on a field that contains the number of labels to print. How
can I do this?
Thanks in advance.
Ron

 

[Duane Hookom]

Create a table of numbers with a single field [Num]:
tblNumbers
1
2
3
4
5
6
....
Add enough numbers (records) to match your max quantity.
Add this table to your report's record source query. Don't create any join
lines. Add the Num field to the grid and set its criteria to
<=[YourQtyField]