print product labels based on order quantity

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.
 
D

Duane Hookom

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