Filter subform for null value

  • Thread starter Thread starter Obeide115654
  • Start date Start date
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?
 
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)
 
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?
Click to expand...
Click to expand...
 
Back
Top