Thanks Derk, That's an acceptable solution... >Maybe not the most elegant solution, but certainly one that would work is > >select * from [your table] where [pick 1 record] into table [temporary table] >select [your table] >append from [temporary table] > >this would copy and insert any selected records, including the general field contents. I would prefer to use a cursor, but the help says you need to append from either a file or an array, so you need to delete the temp table afterwards.