Creating multiple records from one record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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://community.compuserve.com/msdevapps
 
Back
Top