COUNT GRADES

[MAZLAN]

I have given grades to my students from A - E for nine subjects. My problem is how to count how many A's, B's ...E's.. they got for every student out of nine subject that they take.

 

[Mitch]

What is the structure of your table(s) ? is it relational or just a single fixed table ?

Mitch.

 

[MAZLAN]

Its a relational table. One for the marks and the other is the table for the grades.

 

[MAZLAN]

Thanks Mr. Pat for your suggestion but i'm not sure how to implement it because I have 9 grades fields for 9 subject. For your information, I am using duplicate grade tables for every subject. I dont have StudentID fields in Grade Table. It consists of number 1 - 100 in marks field and the grade at the other field. I join the marks field of the student table and the marks field of the grade table to get the grades. I have 9 duplicates grade tables to do that.