Hallo all,
I wish to request for help regarding how to analyse student marks to generate grades from the database. i have the following records that hav captured from the school.
[IMG]\\10.10.10.1\Fine-Xtreme\Member Passports\photos stll\class datasheet.jpg[/IMG]
from the image attached, a student will apear several times cox there three exams per semester. e.g. if peter is in class 4 term 2, then he will have results for exam 1, exam 2 and final exam for this semester. how can i analyse this data so as i have all the three exam results added to give me one score for the term for a specific subject.

please help.