Getting Data in one table that doesnt match that of another Table

[Crash1hd]

How woudl I go about doing that I tried this but it didnt work

SELECT Employees.Initials, Inbound.Inbound_ID, Soft_Skills_Inbound.Inbound_ID
FROM (Employees LEFT JOIN Inbound ON Employees.Initials = Inbound.Initials) LEFT JOIN Soft_Skills_Inbound ON Employees.Initials = Soft_Skills_Inbound.Initials
WHERE (((Inbound.Inbound_ID)<>[Soft_Skills_Inbound]![Inbound_ID]));


I figured cause its looking for something that doesnt exsist but I am not sure how to approch it

 

[neileg]

This is one area where I let the Access wizard take over. There's an unmatched records query wizard.

 

[Crash1hd]

Very Very Excelent Advice thankyou