Filter subform for null value

[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?

 

[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)

 

[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.

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!)

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?