Need help writing select statement

[PJHAction]

I have tblpersonnel with SSN (Join one)
to tblEvaluations with SSN (many) and EvalDate (1 per quarter)

End result, I need to know who has not received an evaluation after a certain date.

I want to select All records in tblpersonnel and only records in tblEvaluations where the date is null or they do not have a record over 4/1/2008 but do not show me records that are below 4/1/2008

 

[PHV]

What have you tried so far ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886