Highest Score sort in duplicate values

[geocan2006]

Hi, I have a table with duplicate values in Names Column, it consist of 2 columns, Name and Score, I need a query to indicates unique value in Name with highest in score only,
Thanks

[pbaldy]

Try a totals query:

SELECT NameField, Max(ScoreField) AS MaxScore
FROM TableName
GROUP BY NameField

[geocan2006]

Thank you, worked like a charm

[pbaldy]

Happy to help!