prevent duplicate top values in a query

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

Guest

I have a query to list the top two scores for a competitor but get three or
more results where there are multiple instances of the same score
 
Statistically, 3 instances of, say, a score of 53 could all three be the
"top" score (i.e., which value is the highest).

I suppose one (brute force) approach would be to first query to find unique
values, then query the query to find Top 2.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
That is the way TOP works.

You can add the the Order By clause to force a unique sort - try adding the
primary key field(s) of the Competitor Scores table to the order by clause.
 
Back
Top