Select Count Problem

[ndehhh]

I have this form which allows students to register for courses. However, each student can only register for 6 courses.



The studentID of each student appears each time the student registers for a course.
(I.e A student registers for 5 courses, then the student has 5 rows of studentID and Course)


How do I count the number of times the studentID input into the form appears in the table?

[CJ_London]

depends on where you are counting from (form/query/vba)

in a query you might use SELECT count(*) FROM myTable WHERE StudentID=1

or you can use the dcount function - DCount("*","myTable","StudentID=1")

[InsuranceGuy]

I suspect you're indicating that you only want the count of distinct StudentID values.

https://www.google.com/search?espv=2...t+count+access