SELECT Players.[First Name], Players.[Last Name], Players.City, Players.[Team Name], Players.Position, Max(Players.[Year Drafted]) AS [MaxOfYear Drafted], Players.[Jersey Number]
FROM Players
GROUP BY Players.[First Name], Players.[Last Name], Players.City, Players.[Team Name], Players.Position, Players.[Jersey Number]
HAVING (((Max(Players.[Year Drafted]))=Max("Year Drafted")));