probably simple Access query help.

M

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
 
J

John Spencer (MVP)

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