Eric, Just noticed that you do want to write a function. Here is the simplest code (assumes same structure in all tables):
Insert Into MyTable1 Select * From MyTable2 Insert Into MyTable1 Select * From MyTable3 Insert Into MyTable1 Select * From MyTable4 Commit Table MyTable1 Mike --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7610
