Get highest # for each unique name comparing 2 fields

[shad0w4life]

I need to get the highest # per name

Eg.
ABC 4
ABC 5
ABC 3

Would show up as

ABC 5


I'm hoping it is simple, but i'm new to SQL and don't have any decent books available to me right now.


Edit: I believe I solved it using a totals query. Correct me if I am wrong though please

 

[Norie]

A totals query is what I was going to suggest.

If you are getting the correct results using that method then it certainly sounds like you've solved it.