Top Scores Top Scores TrekBiker (TechnicalUser) (OP) 28 Nov 15 16:17 A scores table looks like this, recording each player's score on a number of competition days. CompDate, Player, Score I'd like a query that picks just the winners on each date. So shows Date, winner (or ties) and winning score. RE: Top Scores dhookom (Programmer) 29 Nov 15 00:33 The simplest method is to first create a query of top scores by date: qgrpTopScores CODE --> SQLSELECT CompDate, Max(Score) as MaxScore FROM tblScores GROUP BY CompDate; Then create another query using the table and new query: CODE --> SQLSELECT S.* FROM tblScores S INNER JOIN qgrpTopScores Q ON S.CompDate = Q.CompDate and S.Score = Q.MaxScore This can also be done in a single query. Duane Hook'D on Access MS Access MVP RE: Top Scores TrekBiker (TechnicalUser) (OP) 30 Nov 15 12:41 Thanks Duane, as ever. I substituted S and Q for my table and field names but then it did the job.