calculating cumulative GPA

[MR at UB]

I want to be able to calculate a student's cumulative GPA given each
semesters credit hours attempted and quality points. The calculation is to
sum the quality points and divide by credit hours attempted so that for each
semester I will have a cumulative GPA (grade point average) as well as each
individual semester GPA. I have a table with each student's identifier, the
semester indicator, their credit hours attempted and their quality points for
that semester. I would like it to be as simple as possible. Thanks - Mike

 

[Marshall Barton]

I want to be able to calculate a student's cumulative GPA given each
semesters credit hours attempted and quality points. The calculation is to
sum the quality points and divide by credit hours attempted so that for each
semester I will have a cumulative GPA (grade point average) as well as each
individual semester GPA. I have a table with each student's identifier, the
semester indicator, their credit hours attempted and their quality points for
that semester. I would like it to be as simple as possible. Thanks - Mike

Assuming you have one record for each semester for each
student. Add a text box named txtRunCredits to the details
section and set it's RunningSum property to Over Group. Add
another text box named txtRunPts with the same property
settings.

In the Student group footer section, use a text box with the
expression: =txtRunPts / txtRunCredits