G
Guest
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?
table - how do I go about setting that up?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
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
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
G
Guest
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.
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.
J
John Spencer
Add both tables to your query grid
Join them on the field(s) that are the key fields (the matching fields)
Field: Your ID Field
Table: IMC Intern Logs
Delete: Where
Criteria: <blank>
Click the Run button or select Query: Run from the menu
BACK UP your database BEFORE you do this. Just in case it doesn't work as
expected.
Join them on the field(s) that are the key fields (the matching fields)
Field: Your ID Field
Table: IMC Intern Logs
Delete: Where
Criteria: <blank>
Click the Run button or select Query: Run from the menu
BACK UP your database BEFORE you do this. Just in case it doesn't work as
expected.
G
Guest
Fantastic - thank you for your help.
John Spencer said:Add both tables to your query grid
Join them on the field(s) that are the key fields (the matching fields)
Field: Your ID Field
Table: IMC Intern Logs
Delete: Where
Criteria: <blank>
Click the Run button or select Query: Run from the menu
BACK UP your database BEFORE you do this. Just in case it doesn't work as
expected.