Create multiple labels

[Bill Beadenkopf]

In an Access report that generates labels, I would like to
create the number of labels for an item based on a
quantity field.
For instance in the report I have:
ITEM QTY
Red Lamp 6
Blue Lamp 12

So I want to print 6 labels that say 'Red Lamp' and 12
labels that say 'Blue Lamp'.

Can anybody point me in the right direction?

Bill

 

[Allen Browne]

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html