I am not good in programming but i have a passion for it. I am creating a Exam Grading system in VB 6.0 with MS Access as back end.
I have a problem here:
I have 2 tables in MS Access (tblGrades and tmpGrades) with fields StdRegno, Term, ExamType, AvgScore, AvgGrade. I would like to extract the positions using AvgScore but i don't know how to handle a tie (Where students have same average score) such that after say two students in number 2 tie, then the next number will be Position 4 (i.e 1, 2, 2, 4, 5, 6, 7).