Copy/paste data from one table to another

[LouG]

I have 3 sets of tables,.....Want to copy the single record in some of the
first set of tables and paste these to a second table, Copy everything in
2nd table and paste to a 3rd table and then clear out the Second
table......I Dont see a macro command for this, should i be using a
query or the clipboard, This is something I need to happen when a
command button is clicked.......Thanks

 

[Guest]

hi,
not sure what you mean by "sets of tables" but....
from what you said, i see at least 3 queries.
1. an append query to select the record(s) from the first
table to append to the second table
2. an append query that will append the contents of the
second table to the third.
3. a delete query to clear out the second.
these three queries can be run back to back from a button
useing the docmd.openquery method.