DIsplay a field other than the aggrogate function field

[jacquelinewalton]

I have a field called MemberName(text) and a field called goldsmithing(number)

I want to display the MEMBERNAME who has the highest goldsmithing rate.

I have:

SQL = "Select * from Members Where Goldsmithing = MAX(Goldsmithing)"

Its giving me an aggrogate function error. Can someone please explain how to do this?

 

[amorous]

SQL = "Select Top 1 * from Members ORDER BY Goldsmithing DESC"

-VJ