Creating multiple records from one record

Creating multiple records from one record

Post by TWFyZ2 » Thu, 09 Dec 2004 04:17:08


I am trying to create an export file from MS Access to import into
Quickbooks. For each record in my Access Table, I need to create three
output records. I was able to do it by creating a report, but that required
additional manually handling after I exported it to Excel. SO I would rather
do it by creating a new table with three records for every one record.

Any ideas?
 
 
 

Creating multiple records from one record

Post by John Vinso » Thu, 09 Dec 2004 08:22:28

On Tue, 7 Dec 2004 11:17:08 -0800, "Marge"



Rather than creating a new Table, create a Query and export from that.
Add a new table to your database, named Num, with one field N.
Manually fill it with three records, N = 1, 2 and 3 respectively.

Add Num to the query you're exporting, with NO join line. Access will
triplicate the data for you (and you even can use the value of N to
identify which of the three copies you're using).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://www.yqcomputer.com/