Deleting any rows containing values in another table's rows

[Shmueldabomb441]

I have a database which stores records of audio lectures available on a website. Each audio lecture has a representation in my Access file and an accompanying lecture id in the table titled AI_lectures. One column in AI_lectures has the lecture's title, and another has its unique id. I found that there are some duplicate lectures from a particular speaker on the website, except the duplicates have ".MP3" at the end of it. Obviously, the ".MP3" lectures have different unique id's than their non ".MP3" counterparts. I have manipulated the range of lectures in an Excel spreadsheet and found the id's of the duplicates. Say i were to copy/paste the range of duplicates into another table called AI_duplicates. I would like to have a way of deleting any entry in AI_lectures which has an id which is also found in AI_duplicates. Anyone have any ideas? a macro maybe?

Thanks a million!

[ranman256]

One way is to create a list of the iD's you want to delete.
then make a delete query similar to a FIND DUPLICATES query.
use the query wizard and make a find duplicates query,
Edit query,
notice the : IN (select ID from table)

Do the same for the delete query,
the ID to delete will use the sub query:
delete * from table1 where table1.ID (in (select table2.id from table2))