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?

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jules" <(E-Mail Removed)> wrote in message
news:6B93FED6-BA23-48F6-A4FF-(E-Mail Removed)...
>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?