>It isn't a huge number of records. There are a large number of fields however. I wouldn't mind doing it one record at a time if need be. I simply need to copy the records and append them to the end of the table, then change one identifier field.

If you do this manually, you can use SET CARRY ON, and browse the table. A simple Ctrl-Y will copy the current record to the end of the table, and move the cursor to this new record.