Rocky Smolin
rockysmolin at bchacc.com
Mon Dec 10 20:25:57 CST 2012
Me - I'd use a bit of code and a temp table. I'm sure someone will have a slick way of doing this but that's the method that would take me the least amount of time. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Monday, December 10, 2012 6:01 PM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com