Query to Find the "last play date"

[Guest]

I have a table that has golf scores from several different players. They
don't always play each week. What I need to query is the last time (date)
each player played.

 

[Stefan Hoffmann]

hi,

I have a table that has golf scores from several different players. They
don't always play each week. What I need to query is the last time (date)
each player played.

SELECT PlayerNameOrId, Max(yourDateField)
FROM yourTable
GROUP BY PlayerNameOrId


mfG
--> stefan <--