How do I duplicate a record in access by a factor in that record?

[Guest]

I have a table in access that contains order details for instance. The
record contains the following fields - Product Name, Barcode, Qty for
example. I am trying to run a report to a label printer that will print
labels for each product in this order. The way I have thought to do this
without making a print queue (not too hot at programming!) is to dupliucate
each record for the particluar product ordered by the number ordered and then
these can be run to a label printer. How would I be able to do this?

 

[Allen Browne]

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

The article explains how to create a query that generates a record for each
label.