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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
