Filter subform for null value

O

Obeide115654

Hi ,
I have a parent form [Students] with a primary key "STID" this form has a
subform [Placements] which takes the student information from "STID". I need
to filter for those students that haven't had a placement. This means
looking for information that isn't there as those students will have no
record of any placement. Any ideas?
 
D

Douglas J. Steele

I'll assume that the parent form deals with the Students table, and that the
subform deals with the Placements table.

You need a query:

SELECT STID, Field1, Field2, Field3
FROM Students
WHERE STID NOT IN (SELECT DISTINCT STID FROM Placements)
 
O

Obeide115654

Thank you for yor help with this. I literally just found the answer was to
run the unmatched query wizard. Thank you so much for your post.

Douglas J. Steele said:
I'll assume that the parent form deals with the Students table, and that the
subform deals with the Placements table.

You need a query:

SELECT STID, Field1, Field2, Field3
FROM Students
WHERE STID NOT IN (SELECT DISTINCT STID FROM Placements)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Obeide115654 said:
Hi ,
I have a parent form [Students] with a primary key "STID" this form has a
subform [Placements] which takes the student information from "STID". I
need
to filter for those students that haven't had a placement. This means
looking for information that isn't there as those students will have no
record of any placement. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top