Query to Find the "last play date"

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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 <--
 
Back
Top