Can you help me create a query that calculates current overall GPA?
The database is for only one student. It contains two tables (screenshot attached)
(GPA is calculated by dividing the total amount of grade points earned by the total amount of credit hours attempted. Grade point average may range from 0.0 to a 4.0. An A earns 4 points, a B earns 3, a C= 2, a D 1 and an F 0. A W earns no points but indicates that the semester hours for that course should not be counted in the hours attempted total.)
This is my scratch work so far...but I don't know what else to do with it or what else to try...
[[[ SUM DegreeRequirements.Semeste
rHours where CompletedCourses.Grade <> W AND DegreeRequirements.CourseC
ode = CompletedCourses.CourseCod
GradePoints: [CreditHours] * Nz(Switch([LetterGrade] = "A", 4, [LetterGrade] = "B",
3, [LetterGrade] = "C", 2, [LetterGrade] = "D", 1, [LetterGrade] = "F", 0),
GPA: SUM GradePoins / SUM DegreeRequirements.Semeste
(I love Access, I don't know why I always get so tangled up with it :-( )