GPA problem

[lolo]

Hello all....

I have a problem if you solve it you will save my life

i have as you will see 2 queries that used to calculate the GPA of the student, depend on the number of the completed hours and the grades for each student.
This query calculates the GPA depends on the grade and if I don’t enter any grade for any course for the student the query will consider the grade F (zero) and will calculate the GPA in wrong way.


My request that I need to make a modification so that if I enter a course for any student I can consider other letter than (A,B+,B,C+,C,D+,D,F) for example N
If I enter N, this course will not be calculated in the completed hours and the GPA calculation.
thanx alot in advance

[pbaldy]

Either way you should be able to exclude those records from the calculation by using a criteria in the query. You can either exclude Nulls or "N" or both or whatever.

[ConneXionLost]

Another alternative is to add a course "Complete" flag. This would allow you to record a partial score, yet not use it in the GPA. Please see example: