Thanks to your replies. In the end I went down the path of Jon Gramms 2nd suggestion. Saving the query from Table1 as a temporary table Opening this new table and adding the extra columns required. Appending the records to Table 2 Killing the temporary table.
I was hoping for something a bit more transparent like maybe a way of passing the table names to a Run Menu Command [Table->Append rows to table...] Other methods suggested required intensive interrogation of the table structure with loops and arrays of variables. A simple job that requires a lot more code than I expected. Thanks to all James Torrie --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12621
