wow, I really didn't think it would take so long to run that delete statement, but it's not entirely surprising. OK, the following process will work a lot faster, you just need to be able to create a table, which I think you can handle. I just ran through this and it looks like it works to me. 1) Double click on "create table in design view" and create a table with one field called "playerid". Make it a text column with a field size of 10. Save the table as "toDelete". 2) Click on "Queries" under "Objects". Double click on "create query in design view". Close the small "show table" window that comes up, you don't need that. Right click on the Query window and select "SQL View". 3) Copy the following statements into that window and run them one at a time by hitting the exclamation mark in the toolbar. insert into toDelete (playerid) select distinct playerid from batting where teamid not in ('mil','ml1','ml2','ml3','ml4','mlu','se1') insert into toDelete (playerid) select distinct playerid from pitching where teamid not in ('mil','ml1','ml2','ml3','ml4','mlu','se1') What you are doing here is inserting every player who never played for a milwaukee team into that table. 4) Copy and paste the following statements one at a time into the window and run them. delete from toDelete where playerid in (select playerid from batting where teamid in ('mil','ml1','ml2','ml3','ml4','mlu','se1')) delete from toDelete where playerid in (select playerid from pitching where teamid in ('mil','ml1','ml2','ml3','ml4','mlu','se1')) What you are doing is first inserting every player who didn't play their entire career with a milwaukee team into the toDelete table. Then in step four you are deleting all of the players who played only part of their careers in Milwaukee. What you are left with is a list of every player who never played a day for a milwaukee team. 5) Run this query to delete all of those player from the Master table. delete from master where playerid in (select playerid from toDelete) This should leave you with about 1000 rows in the Master table. These queries won't delete all of the managers. If you want to delete the manager then I'd suggest just opening the master table at this point and sorting by playerid. Then you can highlight all of the rows without a playerid and hit the delete key to delete them. The result is a Master table with 868 players. Again, I'd recommend making a copy of the database before you do any of this.