probably simple Access query help.

  • Thread starter Thread starter Michael Beatty
  • Start date Start date
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
 
SELECT [Player Name], Opponent, Min([Round Score]) as LowScore
FROM TheTable
GROUP BY [Player Name], Opponent
 
Back
Top