probably simple Access query help.

[Michael Beatty]

I've got a query with player name, round score and opponent
I need a query that will display the players names and their lowest round
score for each opponent

 

[John Spencer (MVP)]

SELECT [Player Name], Opponent, Min([Round Score]) as LowScore
FROM TheTable
GROUP BY [Player Name], Opponent