calculation from selected feilds?

[Benjamin Foster]

Im sure this is very easy to do but, how do I create a total feild which will total one feild from each of multiple records? I have a database of students and they all have weekly points, for diffretn weeks. I want to total a students points from a set of weeks. I know how to do search to disply the right student records but how do I total all a students point?

[tlsparker]

There are at least three ways to do this (I'll give some detail on the first and just mention the other two):

1. Use the GetSummary function in a calculation. First, create a summary field called TotalPoints, which is a total of points. For this example, I assume you have a field called week. Then, create a calculation field defined as GetSummary (TotalPoints, week). When you are in a record for a particular week, the calculation field will show the total points for that week.

2. Use a subsummary part in a layout.

3. Use a self-relationship.