### Title

Sum question

### Post

I have a table called courses.

the fields I have are:

-student_id

-course_number (up to 30 repetitions)

-earned_cr_hrs (up to 30 repetitions)

-grade (up to 30 repetitions)

-gpa_points (up to 30 repetitions)

mult_poins_potential = calculation (gpa points * earned cr hrs)

I need the total sum of mult_points_potential (of all 30 repetitions(repetition 1+ repetition 2, etc)). Is there a way to get that?

Ick, repeating fields! 98% of the time, you are better off replacing them with a table of related records where each related record takes the place of one repetition.

I assume you want the total gpa * the total earned cr hrs.

Sum ( gpa_points ) * sum ( earned_cr_hrs )

Sum will add up the repetitions when the field in the parenthesis is a repeating field.