Comparing one Q to another Q and recording the difference

[Huddle]

I have two Queries, QryPost_FSL_Before_Last_Two_Weeks and QryPost_FSL3_Within_Last_Two_Wks_More_Than_One_Ins pection. I know long names.... Anyway, QryPost_FSL_Before_Last_Two_Weeks has the total list of buildings I am looking at. QryPost_FSL3_Within_Last_Two_Wks_More_Than_One_Ins pection has those inspected. I need to find the buildings that were not inspected out of the QryPost_FSL_Before_Last_Two_Weeks query.

I've attached the skeleton of the queries. I don't know how helpful they will be without the data or tables but it may give you an idea of what I'm working with.

[June7]

Sounds like a Find Unmatched query. There is a query wizard for that.

Or try something like:

SELECT * FROM QryPost_FSL_Before_Last_Two_Weeks WHERE BuildingID NOT IN (SELECT BuildingID FROM [QryPost_FSL3_Within_Last_Two_Wks_More_Than_One_Ins]);

[Huddle]

The unmatched query was exactly what I needed. Thank you for pointing it out.