Cut & Pasting Rows?

[Guest]

How do I make a macro or some other function that allows user to choose any
row from a database which is then automatically cut & pasted to another
pre-speficied table (which acts kinda like an archive)?

 

[Alex Dybenko]

I think Append query best solution for this. first make a select query, make
it show rows you need based on selection criteria and then change it type to
append query, specifying destination table