any function for moving a record?

[loonatik]

I want to move a record from table1 to table 2. Is there a function to do that, cuz I don't see one in the manual. Would I have to fetch the record from table1, insert to table2, then delete it from table1.

Thanks.

[raf]

first use an append query --> (confusingly enough has a differnt syntax then the Jet or Oracle version (which use) with MySQL it's a "insert select" query
http://www.mysql.com/doc/en/INSERT_SELECT.html
then delete the record from the original table.