Figuring out GPA in Expression Builder

[s.r.grace]

I'm trying to make a specific form so I can add keep track of my
fraternity brother's bills, grades, and positions in the house. Right
now I'm stuck on their grades. I want figure out how to do their GPA in
expression builder. The FINAL_GRADE column has a letter grade, and I
have TOTAL_CREDITS of each class. How would I go about doing this?

Thanks!

 

[John Vinson]

I'm trying to make a specific form so I can add keep track of my
fraternity brother's bills, grades, and positions in the house. Right
now I'm stuck on their grades. I want figure out how to do their GPA in
expression builder. The FINAL_GRADE column has a letter grade, and I
have TOTAL_CREDITS of each class. How would I go about doing this?

Thanks!

Probably with a totals query, but since I have no idea how YOUR school
calculates numeric grades based on letter grades, I can't be very
specific. You'll probably want a GradeScore table with records like

F 0
D- 0.5
D 1
....
A 4.0
A+ 4.3

or whatever; join this to your letter grade table, multiply the score
by the number of credits, etc.

It's more than can be done with just a simple expression.

John W. Vinson[MVP]

 

[s.r.grace]

Probably with a totals query, but since I have no idea how YOUR school
calculates numeric grades based on letter grades, I can't be very
specific. You'll probably want a GradeScore table with records like

F 0
D- 0.5
D 1
...
A 4.0
A+ 4.3

or whatever; join this to your letter grade table, multiply the score
by the number of credits, etc.

It's more than can be done with just a simple expression.

John W. Vinson[MVP]

How would I be able to put that into a text box on a form (since I wan
thteir overall GPA)?

 

[John Vinson]

How would I be able to put that into a text box on a form (since I wan
thteir overall GPA)?

A DLookUp expression retrieving the calculated value from the Query
would be one way.

John W. Vinson[MVP]

 

[s.r.grace]

A DLookUp expression retrieving the calculated value from the Query
would be one way.

John W. Vinson[MVP]

I got it working a different way. I added a couple of columns to the
Grades table, and I then when to a Tabular form, and did the
calculations in 3 seperate text boxes. Not the most efficient way, but
it works.

Thanks for your help.