Query to return name if no record found

[jrosen12]

I'm going to try and explain this the best way I can. I'm not entirely sure this is possible, and I've been toying with it for a bit to try and get it to work...



I have a table (tblTeamMembers) that has the fields: AuthorizerName and LastClassDate.
I have another table created called (tblMeetingLog) with the fields: AuthorizerName, MeetingType

I want to design a query that looks at tblTeamMembers compared to tblMeetingLog and only return the names from tblTeamMembers that do not appear in tblMeetingLog.

For example:
tblTeamMembers has "Test, Test" under AuthorizerName and LastClassDate of 12/1/2014
tblMeetingLog has "New, New" under "AuthorizerName", and "Test, Test" does not appear on this table at all.

I want it to just return the name "Test, Test" because it does not appear on tblMeetingLog.

I hope that makes sense.

[JoeM]

Sure, it can be done. And Access has a built-in Query Wizard called "Find Unmatched Query Wizard" which will walk you through the process.