Filter out records from one query by removing records in other que

[Guest]

In our office's database, I am doing a query on student records who have
entered between two time periods. I have a query that lists the total list
of students that entered during that time period, then one for those who
transferred out during the first term after entering (another range of
dates), another one for second term, third term, et cetera. I added up all
records in the ten terms and am six student records short in the individual
queries for the inclusive query.

Is there a way to filter the original total query to remove all of the
records that are located in the other queries, leaving only the student
records that are for some reason not showing up in the individual queries, so
I can figure out why they are being excluded by looking at the specific
records?

I hope my question makes sense.

 

[guido via AccessMonster.com]

I assume there is a unique field you can query on, like student id, an auto
number, etc. Create a query that links the total query to the other queries
using an outer join. This is done by double clicking on the line between the
queries and selecting "All records from [total query] and only matching
records from [other query]. Then add the records from the total query that
you want to see. Also, add the key field from the other queries. Then, put
the criteria "Is Null" under the fields for the other queries. That should
return the records where there are no matches in the linked queries.