I am using the following SQL in a query to generate a list for a mail merge (it is a make table query):

SELECT tblMembers.MemberID, tblAddresses.AddressMain, tblAddresses.AddressOther, tblCities.CityName, tblAddresses.StateCode, tblAddresses.ZipCode, tblMembers.FirstName, tblLiterature.LiteratureName, tblMembers.EnrollmentDate INTO tblTEMPPrintLetters
FROM ((tblMembers INNER JOIN (tblCities INNER JOIN tblAddresses ON tblCities.CityID = tblAddresses.CityID) ON tblMembers.MemberID = tblAddresses.MemberID) INNER JOIN tblDisenroll ON tblMembers.MemberID = tblDisenroll.MemberID) INNER JOIN (tblLiterature INNER JOIN tblMemberLiterature ON tblLiterature.LiteratureID = tblMemberLiterature.LiteratureID) ON tblMembers.MemberID = tblMemberLiterature.MemberID
WHERE (((tblLiterature.LiteratureName)=[Forms]![frmChooseLetter]![cboChooseLetter]) AND ((tblMembers.EnrollmentDate) Between [Forms]![frmChooseLetter]![txtFromDate] And [Forms]![frmChooseLetter]![txtToDate]));

What I would like to know is if I can use a dlookup to look up members in tblDisenroll so that I do not send disenrolled people a letter.

I have tblMembers and tblDisenroll joined by MemberID.

You do not want to use Domain Aggregate functions like DLookup in a query. It will make them very, very slow.

That being said, if you have the table linked in the query already, just add the MemberID from tblDisenroll to your query, and set the criteria to Null. That will give you all members that do not have a MemberID in tblDisenroll. You can remove the check mark so the field doesn't show in your query output if you'd like.

Thanks for the advice. I will give that a try.

Have a good evening!