I am new in access. I am making a student database. I have created a combo boxes for the following subjects
English
A
1
2
3
4
Mathematics
A
1
2
3
4
Physics
A
1
2
3
4
Biology
A
1
2
3
4
Now
A- Absent (student missed exams)
1,2,3,4 are marks for present students
My question is i want a query to add only numbers and leave A and also to rank students after getting totals for each students. I will appreciate. Please.