How to only see results in a query if the primary key shows up a minimum number of times in the list

[dlong]

Hello, I have very very limited Access knowledge and a very cursory knowledge of SQL commands, so I'm having a lot of trouble making this happen although I'm sure it can be done.

I am trying to make a query that only shows me results for primary keys that have at least 4 results. Specifically, the primary keys are student ID's, and each result is a course the student took. I only want results in my query for students who took at least 4 courses. I was able to figure out how to limit by time period, but this stumping me.

Things I already tried (but maybe not very well):

--Using "count" in the criteria field for Student_ID (syntax may have been off)
--Adding a count under WHERE in the SQL view (syntax was almost definitely off)

Thanks in advance for any help.

[June7]

Try

SELECT * FROM Students WHERE DCount("*","StudentCourses","Student_ID=" & [Student_ID)>=4;

or

SELECT * FROM Students WHERE Student_ID IN (SELECT Student_ID FROM StudentCourses GROUP BY Student_ID HAVING Count("*")>=4);

or

SELECT * FROM Students INNER JOIN (SELECT Student_ID FROM StudentCourses GROUP BY Student_ID HAVING Count("*")>=4) AS Q1 ON Students.Student_ID=Q1.Student_ID;