Creating a delete query

[mmcgibbony]

I have created a query of two tables, Table 1 and Table 2. I have joined the two tables on the field FedID where I have selected to show all values where I list all values in table 2 that are equal to those in table 1. I get a return quantity of 4800 records.

I want to delete these records from Table 1. I click the delete query icon and hit run. It says that I must select which table I'd like to delete the records from. I can't find how to select which table I want to have these records deleted from.



I can't find the answer to my problem. I've looked at videos and online but all of the information I get points me to VBA stuff that I can't decipher. Can anyone help me with this?

Thanks a ton!
Mike

[June7]

Maybe:

DELETE FROM Table1 WHERE FedID IN (SELECT FedID FROM Table1 INNER JOIN Table2 ON Table1.FedID = Table2.FedID

[mmcgibbony]

Thanks, June7. I see this as the possible solution that you have kindly provided to me:

DELETE FROM Table1 WHERE FedID IN (SELECT FedID FROM Table1 INNER JOIN Table2 ON Table1.FedID = Table2.FedID

It creates a couple of questions to help me to clarify my next actions.
1. I see a SELECT command. That is SQL to me. I don't see a closed parentheses at the end of the statement. I understand the logic of the command but I can't tell where to put the command.
2. The mechanics of what I'm doing was
- After creating my SELECT Query in Access
- I clicked the Delete Query button and then clicked RUN
- I got an error.
- Where do I go in Access to either enter this statement or execute the equivalent. I'm so lost.....

Thanks again for the help and clarification.

Mike

[mmcgibbony]

With your help, I was able to execute the DELETE Query. I really appreciate the help. IT WORKED!

[June7]

Glad you figured it out. The forum converted ) ; into emoticon in earlier post.