Is the create/delete tmp table the appropriate way to copy records, manipulate some of the fields and copy the revised data back into the original table as new data or is there an easier way?

---

Reply from Alex Hedley:

You could do it a record at a time with an UPDATE query.
Just depends exactly what you want to do and how may changes you need to make.