Automating moving records from one table to another...

[sftwrdvlpr]

I posted this before but didn't get the help I need. I'll try to be more
informative this time.

I have two tables created in my database. One called Master the other called
Finished. Sorted records in the Master table periodically need to be taken
out and moved to the Finished table.

What I do now is sort the records in the Master table, select the ones that
need to be moved (by highlighting them), do a Cut, go to the Finished table
and Paste the records in. Please tell me how to automate this process.

Someone suggested using a Make Table Query, but doesn't that create a new
table? I already have my tables created.

Thanks,
Fred

 

[sftwrdvlpr]

Worked great! Thanks.

Fred,
depending on your level of skill, you could try using
an 'append' query followed by a 'delete' query. Be
careful what criteria you use to do the selection and
especially the delete. You may even look at the delete
query being driven by the records in your Finished table.

Cheers
Peter