simple running total problem

[timeh]

I'm designing a database for a local athletics event, in which there are 4 teams which compete at different age levels in different events.
The problem is, it is necessary to keep a running total of the points each team has, i.e. whenever the user enters the number of points a team won from an event, it needs to be automatically added to a runnning total. There is probably a very easy way of doing this, but i am relatively new to access and any help would be greatly appreciated. At the moment i intend to have a table "running totals" in which there are 4 fields, 1 for each team. What i need is for these fields to be updated every time a score is added into a corresponding field
for example
if "10"points were entered into a field for team 1
I would then want these 10 points to be automatically added to team 1's running total.

thanks in advance

 

[Geoff Codd]

the easiest solution would be to create a report and set the running sum property from the fields property box. Look at running sum under help.