Finding Max lift or top 5 performers

[Greg553]

Hello again.

I have a Situation where I want to get the top 5 or 10 performers in a certain lift. I have a table that of course has many records and multiple records for the same player.

My table is set like this

tbl_weightlifting
Weight_ID
Player_ID
Lift_ID
Weight lIfted
Date

i know how to run the Query to find the bench press records, but how do I filter it to get just the max lift for each player and only the top 5. Each player has a history of records in teh table

 

[Greg553]

Well after some work I figured it out...
Works fine now