printing differing number of labels

  • Thread starter Thread starter Ron DeGregorio
  • Start date Start date
R

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
 
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]
 
Back
Top