Filter out Students that have passed any class

[Flairo]

I have a table with this example information:

Student	Grade
John	A
John	C
John	A
Lucy	F
Lucy	B
Lucy	B
Adam	F
Adam	F
Adam	F

I am trying to make a query that produces this:

Student	Grade
Adam	F
Adam	F
Adam	F

If the student has passed any of their classes, I want to take them out of the list.
John passed all classes, out of the list. Lucy passed at least one class, out of the list. Adam failed all classes, keep in the list.

[andy49]

Create a group query to return names of people who only have f

Then query this query with original tblresults.


Sent from my iPhone using Tapatalk

[ssanfu]

Maybe

SELECT Table1.Student, Table1.Grade
FROM Table1
GROUP BY Table1.Student, Table1.Grade
HAVING (((Table1.Grade)="F") AND ((Count(Table1.grade))=3));

Obviously, change "Table1" to your table name.......

[Flairo]

Thank You! ssanfu, works great.

[ssanfu]

Great....... I'll mark this solved???