I have a table called "Belts"
Mfrname - Text
In Table I have repeating values in the Mfrnum field when a filter is in place for the Mfrnum field for a particular value like as shown.
In this case i'm filtering "1000H075" in the table.
What I need: based on the "Score" field. What ever score record has the highest value in the "Score" field. Then a "Y" gets placed in the "Tag" Field for only the highest value score.
In the case where the highest value is the same pick the top records in the filter.
I'm indexing by "Mfrnum" asc... and then "Score" descending in the filter.