Hi! I'm sure that this is easy, but I just can't solve it. Could you please help?
Access 2010
I have a form that displays all students in my program and all classes that they take, kind of like this:
STUDENT ID CLASS MARK
All I want to do is create a calculated field that displays the total number of classes that student is taking, like this:
STUDENT ID #Classes CLASS MARK
John Doe 2 Math 30 88
John Doe 2 English 30 67
Jane Deer 1 Physics 30 99
and so on. I tried using the COUNT function (it says 1 each time, as these are not grouped), then I tried to do this in the query (same thing), then I tried to first COUNT them SUM them in the query (complains about subqueries and aggregate functions).
Any ideas? Thank you in advance!
Melody