Welcome to the forum
Change to an OUTER JOIN and use Is Null as shown below - its called an unmatched query - there is a wizard for doing this
This query gives the unmatched partnumbers in the table Tbl_QP_Partnumbers:
Code:
SELECT Tbl_QP_Partnumbers.Partnumber
FROM Tbl_QP_Partnumbers LEFT JOIN Qry_Insp_Plan_Created_Data ON Tbl_QP_Partnumbers.Partnumber = Qry_Insp_Plan_Created_Data.Partnumber
WHERE Qry_Insp_Plan_Created_Data.Partnumber Is Null;
This one gives the unmatched partnumbers in the query Qry_Insp_Plan_Created_Data:
Code:
SELECT Qry_Insp_Plan_Created_Data.Partnumber
FROM Tbl_QP_Partnumbers RIGHT JOIN Qry_Insp_Plan_Created_Data ON Tbl_QP_Partnumbers.Partnumber = Qry_Insp_Plan_Created_Data.Partnumber
WHERE Tbl_QP_Partnumbers.Partnumber Is Null;
And to get both of these in the same output use a UNION query based on both of those.
You can't do this using the query design window; change to SQL view and paste in the code
Code:
SELECT Tbl_QP_Partnumbers.Partnumber
FROM Tbl_QP_Partnumbers LEFT JOIN Qry_Insp_Plan_Created_Data ON Tbl_QP_Partnumbers.Partnumber = Qry_Insp_Plan_Created_Data.Partnumber
WHERE Qry_Insp_Plan_Created_Data.Partnumber Is Null;
UNION SELECT Qry_Insp_Plan_Created_Data.Partnumber
FROM Tbl_QP_Partnumbers RIGHT JOIN Qry_Insp_Plan_Created_Data ON Tbl_QP_Partnumbers.Partnumber = Qry_Insp_Plan_Created_Data.Partnumber
WHERE Tbl_QP_Partnumbers.Partnumber Is Null;