[AccessD] Create Multiple records in report

This is not a direct Access question but more a SQL problem.

 

I have a table that has order addresses and number of items ordered.  I want
to create a label for each item shipped.  If I have an order for 3 widgets
then I want 3 labels.  Is there a simple way of creating a record set with
the number of records equalling the number of items shipped (and not the
number of orders)?

 

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand