G
Guest
I am setting up a database to produce some running race results, where tables
of entrant data are merged with a table of finish position through the common
key of race number.
To produce team results, I need to sum the finish positions of the three
members of each club in each age category which have the lowest finish
position.
The easiest way that I can see is to do a crosstab query - since I have many
teams and many categories, but access won't let me sort, pick out the top 3
and sum them up to form each result.
Is there a way of doing this?
of entrant data are merged with a table of finish position through the common
key of race number.
To produce team results, I need to sum the finish positions of the three
members of each club in each age category which have the lowest finish
position.
The easiest way that I can see is to do a crosstab query - since I have many
teams and many categories, but access won't let me sort, pick out the top 3
and sum them up to form each result.
Is there a way of doing this?