Sum of top 3

[phabio]

I have a Table with the Fields
NAME RACE SCORE

I need to generate a Report like That
______________________________________________________
NAME John POINT 101 (SUM of best 3 SCORE !!!!!)
------------------------------------------------------
RACE SCORE
- - - - - - - - - - -- - - - - - - - - - - - - - - - -
aaaa 51
bbbb 26
cccc 24
dddd 18
eeee 11



NAME Bob POINT 50 (SUM of best 3 SCORE !!!!!)
------------------------------------------------------
RACE SCORE
- - - - - - - - - - -- - - - - - - - - - - - - - - - -
aaaa 21
bbbb 19
cccc 10
dddd 3
...


My big problem is how can I calculate the sum of the best 3 SCORES for each NAME.

Please Help
Ciao
Fabio

 

[JeremyNYC]

Put the Race and Score data in a sub report. Make the recordsource of that subform start SELECT TOP 3. Link the main and sub reports on the PersonID, or whatever is the PK for the person table.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.