Problem with Delete query

[JoanieB]

I have tried using both a select query (not a grouped or action query) as well as a table to show which records I want deleted from another table. In the original selectquery, I individually selected each field (not*). Whenever I try to run the delete query it tells me I have to select which table I want to delete the records from...the design view will not let me. If I add a field to the list and try to change it from "where" to "From", it will not let me. Can anybody help with this?

 

[dswitzer]

Try this one.

Table1 has multiple fields you wish to delete, and a field called ID.
Table2 has match field (let's call it ID2) as your selection criteria.

You want to delete all information from Table1 where Table1.ID = Table2.ID2

DELETE FROM Table1 WHERE ID in (SELECT ID2 FROM Table2);