How do I take an average of alphanumerics?

[Nick Richards]

Hi folks,
Hoping you can help me out.
At uni we have an alpha-numeric grading system, where A16 is a top pass and F1 is an abject fail. I need to average the grades for 2 semesters.
I'm thinking that I need to remove the letter take the average and then put on a new calculated letter (eg.
A16 + F2 gives an average of C9)but don't know where to begin.
Any hints would be very much appreciated.
Cheers muchly
Nick

[ADezii]

Hello Nick:

1. Where, exactly, are these Grades stored? I'm assuming that they are stored in a Related Table Linked by some sort of [ID] Field to a Parent Table, but only you can tell me this info.
2. Kindly Post all the possible Grades, along with their corresponding Values.
3. List your Table(s) structure along with Field names and Data Types.
4. Once we have this, and any other relevant info, we can then proceed.

[Nick Richards]

Hi, thanks for the super quick response.
The grades are in a table called Raw Data, the field names are 'Semester 1 Grade' and 'Semester 2 Grade' both fields are text fields.
The achievable grades are A16, A15, A14, B13, B12, B11, C10, C9, C8, D7, D6, D5, E4, F3, F2 and F1. They don't have corresponding values, I want to average the numerical parts of the grade.
Thanks again

[ADezii]

A16 + F2 gives an average of C9

1. An Average of the Numerical Components equals 9, but what is the logic for arriving at the 'C'?
2. What would the Averages be for : A14 <==> B13, E4 <==> B11, etc.?

[hype261]

It seems to me that your values go from 1 to 16. So why don't you drop the character at the beginning of each grade then average them together and then add the character back on? Wait I just reread your original post and you mentioned this. Here is how I would do it.

dim average as integer
 
average = (CInt(Right(gradeOne,Len(gradeOne)-1)) + CInt(Right(gradeTwo,Len(gradeTwo)-1))) /2