Ranking with allowance for tied scores 1

[TrekBiker]

I need to extract 1st, 2nd and 3rd scores from a table, allowing for tied scores.

An abbreviated example of the table (it has many more rows for each date)is

The results for each date need to be like this, limiting to the top placings, including any ties

I've found various posts about ranking but not quite what I want.

 

[TrekBiker]

This was the query I tried

SELECT Dupe.CompDate, Dupe.Player, Dupe.Points, Dupe.Points
FROM tblScores AS Dupe
WHERE (((Dupe.Points) In (SELECT TOP 3 tblScores.Points FROM tblScores WHERE (((tblScores.Player)=Dupe.[Player])) ORDER BY  tblScores.Points DESC)))
ORDER BY Dupe.CompDate, Dupe.Points DESC;

It sometimes gave the right result, sometimes going beyond the top 3, particularly when there were tied points.

 

[combo]

You need top 3 for given date, so in [tt]WHERE[/tt] condition you need [tt]tblScores.CompDate=Dupe.CompDate[/tt] instead of linking by [tt]Player[/tt].

combo

 

[TrekBiker]

Ah, great! Thanks Combo, moment of madness now rectified and working properly.