How do I move record from 1 table to another

X

XeniaEagle

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
 
N

Nick Coe \(UK\)

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.
 
Top