Mrsostrich
Registered User.
- Local time
- Today, 15:47
- Joined
- Sep 28, 2002
- Messages
- 21
I am storing module test marks in a table. Each modeule can be repeated once, and therefore my fields are:
Student Id Module ID Session
In order to calculate a final grade I need my query to select the higher of the 2 grades for any individual module and then add up those maximum marks for each module to make a total.
Any ideas?
Student Id Module ID Session
In order to calculate a final grade I need my query to select the higher of the 2 grades for any individual module and then add up those maximum marks for each module to make a total.
Any ideas?
