Hey,
I was not at all clear in what I am trying to do when I posted this hope this edit helps...
I have three date fields that that are associated with all people in the db I want to query. I only want records that have a null in any of the three fields to be returned, and if 1 or 2 of the other fields have dates in them those dates should show as well (see below).
Problem is one person can have a null field in one, two or all three records. I tried using the Is Null but when I line them up my query only returns records that have all three dates null...
I've tried Ruegen's solution but that does not return what I need either...
With that give me a result similar to this? John Smith has the FP and PDCA in but is missing the StPDChk, Jane smith has the FP and StPDChk but is missing the PDCA and Mike Smith has nothing turned in.
Last Name First name DOB Supervisor FPMissing StPDChkMissing PDCAMissing
Smith John 01/01/1980 Mike Jones 12/10/2015 11/09/2015
Smith Jane 11/01/1992 Sue Mi 12/10/2015 11/09/2015
Smith Mike 02/01/1995 Sue Mi
ARG>>>>>