Delete Unmatched Query Results

[mpreston14]

First, I want to thank everyone that participates on these forums, you have been a wealth of information and made building this db so much easier for me. I have also searched but havent found something to what I am trying to do so please forgive me if its obvious....

In my db I have table set up to import basically the same data from 3 disparate sources. I also have a "master people" table where "people" are detailed. One of my import files has data on people from another state that I do not need to include in my database, but "state" is not a field in the data. So before I take the raw data and convert it via my queries for what I need, I want to remove the other states people from the import table.

I have created an unmatched query that pulls first,middle, last names from the import table and matches against the "Master People" table, it works great( people ID is assigned in the "Master People" table so I dont have an ID# to go with from the imported data)..

My question is how do I take those query results and apply a delete to the import table? I've managed to do an append based on another similar query, but delete is a mental block for me!

I am not familiar with writing SQL, but can generally read it, so I need to be able to do it via design view if at all possible.

I appreciate any help you can provide.

Thanks

[June7]

Review http://www.techonthenet.com/sql/delete.php

Sorry, probably will have to type in SQL View.