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