Unmatched Query Question

[Guest]

I'm so bad at trying to get an unmatched query to work. This is what I am
trying to do. Ii have a table that holds all reports that are received on a
given day(tblAMURptsCheck). I have another table that holds all the reports
that are received in the department on any given day. I need a query that
will tell me on a specific day which reports weren't received in the
department. I tried using the unmatch query but I'm either heading in the
wrong direction or I'm not joining it right. Here is what I have

SELECT tblAMUDailyRptsMatrix.FREQUENCY, tblAMUDailyRptsMatrix.[REPORT NAME],
tblAMUDailyRptsMatrix.[BANNER LABEL], tblAMUDailyRptsMatrix.[JOB NAME],
tblAMURptsCheck.DATE, tblAMURptsCheck.[REPORT NAME]
FROM tblAMUDailyRptsMatrix INNER JOIN tblAMURptsCheck ON
tblAMUDailyRptsMatrix.[BANNER LABEL] = tblAMURptsCheck.[BANNER LABEL]
WHERE (((tblAMURptsCheck.DATE)=[Enter Date]) AND ((tblAMURptsCheck.[REPORT
NAME]) Is Null));

Can someone please help me?

 

[Guest]

Nevermind - i finally figured it out, thank you