I then have a second query that should return the top two scores from each player in each test. The SQL for that query is posted below.
SELECT qrySource.ID, qrySource.PlayerID, qrySource.TestID, qrySource.Score
FROM qrySource INNER JOIN tblTests ON qrySource.TestID = tblTests.TestID
WHERE (((qrySource.Score) In (Select Top 2 [Score] From qrySource Where [TestID]=[tblTest].[TestID] Order By [Score] Desc, [ID])))
ORDER BY qrySource.TestID, qrySource.Score DESC;
I cannot get this query to distinguish between duplicate scores and it returns all values despite me trying to Order By ID which is a unique value. The above query returns ...