Moving records from one table to another

[badger8]

I have two tables. I have a list of accounts that I would like to look for within one table, and any contact from these accounts I would like to move them to my second table.

How would I do this? Need help

Thank you

 

[BNPMike]

Could you clarify why the normal Append Query doesn't meet you need? mike.stephens@bnpparibas.com

 

[THoey]

I would think the following would work:

INSERT INTO MySecondTable
SELECT * FROM MyFirstTable
WHERE MyFirstTable.MyColumn in ('Value1','Value2','Value3')

If not, please add some more detail... Terry M. Hoey

 

[badger8]

Hi th3856,

The insert into worked. Is there a way after you insert these records into the second table to delete the records from the first table?

 

[THoey]

It would almost be the same query:

DELETE FROM MyFirstTable
WHERE MyFirstTable.MyColumn in ('Value1','Value2','Value3')

Terry M. Hoey