Query Design help

[GACat]

I am trying to create a query that will show all members of a team.
Each team can have up to 7 members
Each member will have a score
I need to sum the scores for each team, but include only the top 5 scores.
Any ideas?
Thanks

 

[vbaInet]

Have a look at this:

http://allenbrowne.com/subquery-01.html

 

[GACat]

Great - Thank you!

 

[vbaInet]

You're welcome.