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

Signature
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
> 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)?