I you want to copy a row from one table to another you can use the SQL syntax "INSERT INTO table2 SELECT * FROM table1 WHERE ..."

Also, you can run more than one SQL statement at a time by separating each with a ;

So, you can do the move(s) followed by the delete(s) in one go. Just make sure you use a transaction.

As Phil suggested, you could have done that easily with DELETE statement with WHERE Clause specifications.

About the Single and Double quotes: Both can be used. But Single quotes fit in better than double quotes around string values(non numeric, for which you don't have to use quotes around), becoz DOUBLE quotes in VBA/VBScript/VB lang is used to wrap the Contants/strings, so within that if you would like to use quotes around string values to contruct sql statement as in your case, you got to use single quotes as specified in my previous post, ot you could use double DOUBLE quotes "" to nullify/negate the special meaning of the preceeding one.

Hope that explains.
Cheers!

_________________________
- Vijay G
Strive for Perfection