Delete Records in One Table from Another

[Erika]

I have a table listing all of the records that I want to delete from another
table - how do I go about setting that up?

 

[Lynn Trapp]

Hi Erika,
Try something like this:

Delete *
From YourTable1
Where YourIDField in (Select IDField2
From YourTable2);

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Erika]

Please forgive me for not understanding - when I select that it is going to
be a delete query I have the following info to fill in:

Field:
Table:
Delete:
Criteria:

My 2 tables are called - IMC-Intern Logs and Deleted Accounts - I want all
the records in the Deleted Accounts removed from the IMC Intern Logs.