Query to Find the "last play date"

K

kwhogfish

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.
 
S

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.
Click to expand...

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


mfG
--> stefan <--
 
Top