Hi all!
About a week ago I thought I had a break through in running a query that would only pull up information for people who had no contact logged for a specified date range. The idea is that I want to know who I haven't contacted since the beginning of August. I tried running the query again today, but people that I have logged contact with in the last week are showing up as no contact in the specified date range. Any ideas what I should be doing different? Here is my SQL code that I'm using.
Code:
SELECT tblMasterList.EMPLID, [Full Demographics].C_EMAIL_ADDR, tblMasterList.FULL_NAME, [Full Demographics].PRI_LAST_NAME, [Full Demographics].PREF_FIRST_NAME, tblMasterList.FTIC_TERM, tblMasterList.STATUS, qryCommunications.COMMUNICATION_DT
FROM
(tblMasterList LEFT JOIN qryCommunications ON (tblMasterList.EMPLID = qryCommunications.EMPLID AND COMMUNICATION_DT >8/1/18 AND COMMUNICATION_DT < 9/20/18))
INNER JOIN [Full Demographics] ON tblMasterList.EMPLID = [Full Demographics].EMPLID
WHERE (((tblMasterList.FTIC_TERM)="FTIC-2168") AND ((tblMasterList.STATUS)="active") AND ((qryCommunications.COMMUNICATION_DT) Is Null))
ORDER BY tblMasterList.FULL_NAME;
Thanks for the help!