Unmatched Query searchin null values for Date Range

[snoozie17]

I have a table with Client info and a table with Client's case notes. Case Notes should be entered weekly and I need a query that tells me if a case note has not been entered for a client within a date range. Grateful for any assistance - I am a newbie to Access :)

[NeoPa]

This one trips people up all the time.

Your inner query (only) should show the notes and be filtered to the date range.

When you have that working you can run a standard 'missing' style query by linking the results of the inner query as a LEFT JOIN to the Client table and filtering for Null in the linked field(s) of the inner query.

So, say the inner query is named qryClientNote and returns two fields to make it unique - [ClientID] & [NoteDate] - and the Client table also has a [ClientID] field to identify Client records, then the outer query might look like (in SQL) :

SELECT tC.*
FROM   [tblClient] AS tC
       LEFT JOIN
       [qryClientNote] AS qCN
  ON   tC.ClientID=qCN.ClientID
WHERE  (qCN.NoteDate Is Null)

[snoozie17]

Thanks for your help NeoPa. Got it working :))