How to sum after a given date?

[Andrew5]

Main table is student ID information including a "mid-point" date that is individual to each student. Child portal table has student scores, each with a date. I have been trying to make a calculation field that will sum the student's scores after the mid-point date (which is entered into the main table when the student reaches that point). I'm sure this is simple.... Thanks for the help everyone.

[comment]

One way:

Define a new relationship between Students and a second occurrence of Scores as:

Students::StudentID = Scores 2::StudentID

AND

Students::MidPoint < Scores 2::Date

In Students, use Sum ( Scores 2::Score ) to sum the scores after the mid-point date.

Another way:

In Scores, define a calculation field cScoreAfter =

Case ( Date > Students::MidPoint ; Score )

In Students, use Sum ( Scores::cScoreAfter ) to sum the scores after the mid-point date.