Can you limit TopValue function when values are equal?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using TopValue Function in a Query. I want to only select the top 3
scores in the group. When the 3 and 4th number are equal, access selects 4
numbers or as many as are equal. Can I limit the function to just select top
3 regardless of equal values? For example: Top Values are 120, 100, 90, 90,
80, 70. TopValue 3 will return 120, 90, 90, 80, 80
 
You have to give Access some way to decide which one of the equal values you
want.

A simple solution is to add the primary key field to the end of the ORDER BY
clause. Since the key is unique on each row, Access can then differentiate
between the equal values.
 
Back
Top