bubbasmith99
Senior member
ok i have two tables. one has 4000 records, one has 500. most of the records in the table with 500 records are IN the table with 4000 records. however, i want to leave those out and design a query that will present only the records that are MISSING from the table with 4000 records. i know this is easy as all get out but my brain is totally fried and i cant figure out how to run the ms access query to do it. can anybody help?