That can be done by an "Append" query, to "copy" one record from tblA to
tblB.
If you need to delete the original record from tblA after the Append,
then you'll
have to follow that with a "Delete" query for that record, against tblA
The question that comes to my mind, is why do you need to do this? Your
reason may be valid, but it also may be that you only need to add a field to
your table that marks the record you want to move as archived. And then use
that to filter out records in your queries.
