Top Score Per Branch - Can't figure this one out!!

[LanieB]

Hello Ladies and Gents!

My db is used for internal audits. I'm trying to run a query that shows the top score PER branch. I can't figure out what criteria I would need to get this result.
If my fields are as follows: BRANCH, USER NAME, OVERALL AVERAGE. What would I need as the criteria in the query to pull the TOP score PER branch?

Thank you all!

Lanie

[orange]

How do you define Score? What is OverallAverage exactly?
See Top N at http://allenbrowne.com/subquery-01.html

[LanieB]

The overall average is a calculated fields that divides all Points earned by points available - it gives you their percentage. So I would need to determine how to pull one record per branch, for the top percentage. I hope this helps!

[orange]

See Top N at http://allenbrowne.com/subquery-01.html

Did you look at this?