SELECT Trans_Person.FirstName, Trans_Person.LastName, Trans_Person.Phone_Mobile, Trans_Study.ExamPass, Trans_Study.ExamLevelID
FROM Trans_Person LEFT JOIN Trans_Study ON Trans_Person.ID = Trans_Study.PersonID
WHERE (((Trans_Study.ExamPass)<>”pass” Or (Trans_Study.ExamPass) Is Null) AND ((Trans_Study.ExamLevelID)=1 Or (Trans_Study.ExamLevelID) Is Null));

]]>By: tomliottahttp://itknowledgeexchange.techtarget.com/itanswers/access-2003-sql-sub-query-within-query/#comment-107107
Wed, 02 May 2012 05:08:14 +0000#comment-107107So far it sounds like you’re on a good path. Please show the query that you have developed. It can probably be changed to help get you closer.