Move records between tables

[rogueakula]

I have searched pretty extensively and I have not been able to find an answer. I have one DB and right now only one table called personnel. I want to be able to have a button that moves a record from the personnel table to a detached table. I would imagine that this could be done by a move macro followed by a delete macro, but I am not a macro or VB kind of guy Thanks for your help.

[pbaldy]

The easiest way would be with queries, not macros (though a macro could execute the queries). You'd want an append query and then a delete query. That said, if you're archiving people who have left or something, it's usually better to leave them in the table but have a "status" field or something that signifies that they've left.