i have a students database which has names, english, maths, physics and biology
in english i have combo boxes- A,1,2,3,4 In Maths combo box - A,1,2,3,4 and in physics combo box - A,1,2,3,4 and biology combo box - A,1,2,3,4
in this case A-Absent
question- i want access query to sum up the numbers in this fields- english, maths, physics and biology and leave A- meaning the student is absent and also to rank from the highest(student with highest totals up to lowest).
please help me