[AccessD] Create Multiple records in report

One thing to add, there could be several items ordered so if there were 3
widgets and 2 whatszits ordered there would be 5 labels.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Tuesday, 11 December 2012 2:55 p.m.
To: AccessD
Subject: [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

 

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com