Queries with criteria

msouriya

Registered User.
Local time
Today, 08:58
Joined
Oct 20, 2016
Messages
11
Okay, so I have two tables: Services Received TBL and StudentTBL
I linked them by their ID and want to identify students who don't have services entered by adding Is Null on the Criteria Field of the Date of Service. When I go run it, nothing comes up. I've already entered a test student in the form without entering service, and that student should have come up. I hope this makes sense. Please help! :banghead:
 
So people who have no record in the services table? Try the unmatched query wizard.
 
Wow, thanks so much!
 

Users who are viewing this thread

Back
Top Bottom