Queries with criteria (1 Viewer)

msouriya

Registered User.
Local time
Today, 04:02
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:
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 04:02
Joined
Aug 30, 2003
Messages
36,140
So people who have no record in the services table? Try the unmatched query wizard.
 

msouriya

Registered User.
Local time
Today, 04:02
Joined
Oct 20, 2016
Messages
11
Wow, thanks so much!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 04:02
Joined
Aug 30, 2003
Messages
36,140
Happy to help!
 

Users who are viewing this thread

Top Bottom