Using one table to delete records from another

[MitchT]

I have 2 tables: One with around 15000 records and another with almost 4000. All of the records on the small list are on the large one. I need to delete all the records from the large list that are on both lists (the smaller list is people who already bough a product so we don't wat to market to them again).

Any help is much appreciated.

[ranman256]

Use the query wizard and run a FIND DUPLICATES query. It dont matter what, its an example. Just make it on 1 table and view the query design.
You want a delete query similar to this...
In the [ID] field is a 'sub-qry' with the IN command.... in (select [id] from SrcTabl)

Make your qry similar: delete * from tTargTbl where [id] in (select [id] from tDelList))
Delete items from your table that are IN the field of the example table.