print product labels based on order quantity

  • Thread starter Thread starter Auian
  • Start date Start date
A

Auian

I need to create a report to print individual product part# labels based on
the amount ordered. IE: customer orders 78ea of part#1234....So I need 78
labels. Also need to fill across the page. I have the report printing the
part# by order number but do know how to print the part# multiple times based
on order qty.
 
I would create a table of numbers tblNums with a single numeric field [Num]
and values 1 - 1000 (or other large enough number). Add this table to your
report's record source and set the criteria under the Num field to
<= [Order Qty]
 
Back
Top