I have a column named PASS of 'y' & 'n'values. I need to run a querry that will pull a list of students who have 8 'y' only. In design view, I'm o.k. pulling the names & some other info but when setting the criteria under PASS, I can't seem to get the desired result.

Shoul I be using the COUNT or COUNTIF statement? Or any suggestions would be much appreciated. Thank you.