Solved Query To see 0 values (1 Viewer)

[khodor]

Hi, I asked my students to send me time sheet forms by google form
I want to read the forms by using access query to see:
1- who is sending time sheet with time less than 3 hours (i have did that)
2- who is not sending forms at all or some days
I am still can't do the second step.
can you help me

 

[gemma-the-husky]

What you need is

a) query of people who should send forms
b) query of people who did send forms - similar to the 3 hour version
c) an unmatched query to find those in query a) who are not in query b)

 

[khodor]

Thanks a lot
I Tried this way in new access file and it worked well.
But on my access file it didn't work, I Think there is a problem in the relations