Running sum within a group

[Ky-Thuan]

Hi

I have a query which contains scores, assessor's names,
and teamID. I want to get the running sum of the scores
for each team or teamID.

In the query panel, in the SQL view, I used a GROUP BY
clause, but Access doesn't seem to let me GROUP BY only
the teamID, instead, I have to put GROUP BY teamID,
assessor's name, scores, which doesn't do what I want.

I must be able to re-use the running sums elsewhere in a
form. Does anyone know how to do this?

Thanks for your help

 

[Ky-Thuan]

Hi,

Unfortunately, because Access requires that you specify
all columns in the GROUP BY clause, I cannot sum the
scores of each group... even if I put a sum in the desired
field, I get the same value as the score field...