Moving/copying a record between tables

[John E. Fox]

Dear All,

What is the best way to move the current record from one
table to another?
Or copy the current record, then delete it.
Thanks

John Fox

[Allen Browne]

Often the best way is to leave the record in the table, and just flag it as
"Deleted" or whatever by using a yes/no field.

If you do want to move it, you probably want to do so in a transaction, so
you get an all-or-nothing result. Details in article:
Archive: Move records to another table
at:
http://members.iinet.net.au/~allenbrowne/ser-37.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John E. Fox" <al******@bham.ac.uk> wrote in message
news:Us****************@newsfe3-gui.ntli.net...

Dear All,

What is the best way to move the current record from one table to another?
Or copy the current record, then delete it.
Thanks

John Fox

[Pieter Linden]

"John E. Fox" <al******@bham.ac.uk> wrote in message news:<Us****************@newsfe3-gui.ntli.net>...

Dear All,

What is the best way to move the current record from one
table to another?
Or copy the current record, then delete it.
Thanks

John Fox

An Append query, then a delete query wrapped in a transaction, so if
one fails, the whole thing gets rolled back.