How do i delete unmatched data in my Query ?

[Guest]

I ran a query with Table 1 matching it on Table 2 .
I found a lot of unmatched data.
How can I delete the data from Table 1 without doing it manually?

 

[kingston via AccessMonster.com]

Use a subquery to create a delete query:

DELETE [Table 1].* FROM [Table 1] WHERE [Table 1].[ID] Not In (SELECT [ID]
FROM [Table 2];