or . . . .
1) create table with all necessary primary keys and indexes
2) code so that you create a recordset of your query
3) add each record of the recordset to your table
Remember to delete all existing records from the table if you only want the
records in the recordset each time
HTH
Al
