delete query

[Dick60]

I have 2 tables, a source table called 1 and a table called 2 with wrong entries from the source table. I already created that query to select the wrong entries from 1 en copy them into 2. Now I want a delete query that removes the entries from table 2 from table 1.



Pls. give me some help. I am using Access 2010

best regards
DB

[JoeM]

Can you post the SQL code of your query that selects the wrong entries?
What we really need to know is that is the unique connection between the two fields.

[Dick60]

it is the Name of an instrument. sometimes tags typed wrong and I want the removed from table 1 after copy the into table 2.

[JoeM]

The structure would look something like this:

DELETE [Table1].*
FROM Table1
WHERE [Table1].[Name] IN
(SELECT [Table2].[Name]
FROM [Table2]);

[Dick60]

thank you At the moment I am testing it. I let you know.

[JoeM]

Just be sure to make backup copies of your databases or tables before you start deleting stuff!

[Dick60]

JoeM thanks for the help, you helped me a lot. IT WORKS!!!