How do I move record from 1 table to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables Members and Deleted Members
I would like to move some members to deleted members,
but cannot figgure out how to do it
I have tried copy and paste. I have tried putting them in
Excell and import, but nothing works
Thanks for any help.
Roger
 
You'd be better of having them all in the same table but
with an extra boolean column (True/False) called Active or
similar, which is True for members and False for Deleted
members.

Having said that, what you need to look into is an append
query to add the appropriate records to Deleted Members and
a delete query to remove those same records from Members.

I really, really recommend doing it the first way.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
take records out of table and put in new table 6
Searching Across Two Tables For A Record 3
Access 2002 (membership/subscription records) 3
Appending records 1
Populating a table based on data from another table 1
Subform causes Main Form to show the same record multiple times 9
Circular reference? 3

Back
Top