Let me explain a little bit about what I am trying to do because I dont even know the vocab to use to ask. I have an Access 2016 database that records staff QA data. When a staff member misses a QA we assign a job aid that explains the process and they can optionally send back a worksheet showing they learned about what was missed. If they do all of these ina 3 month period they get a credit on their QA score. So I have a series of records all of whom have a date we assigned the work(RA1) and MAY have a work returned date(RC1). 
In the below image “lavalleer” has earned the credit because both of her sheets got returned. “maduncn” Did not earn the credit because he didn’t do one. I want to create a query that returns to me only the people that are like “lavalleer”. I tried hitting google and searched here and access.programmers.co.uk but I’m only coming up with instructions to use Not null statements. That wouldn’t work for me because if I did a IS Not Null on “maduncn” I would get the 4 records but it would exclude the null.
What I need to do is build a query where I can see staff that have dates in ALL of their RC1 fields. If any of their RC1 fields are blank I dont want them to return.
Advertisement
Answer
Consider:
SELECT * FROM tablename WHERE NOT UserLogin IN (SELECT UserLogin FROM tablename WHERE RCI IS NULL);