DELETE QUERIES... need help with 'em.

[steev]

DELETE QUERIES... need help with 'em.

I'm a bit new with Access. Can I use a Delete Query to delete records from one table with the criteria from a different table, and if so, how? Also, can you explain the "Where" and "From" choices in the Delete field of the query. If you reply to this, please spell out your explanation as if a six year old were going to decipher it. Thanx.

 

[ott]

You can delete records and set criteria on a field in another table as long as you add both tables to the query and join them on one or more fields that will uniquely associate the tables with one another. Only select fields from the table that contains the records you would like to delete however.