4 Replies Latest reply on Apr 4, 2012 4:58 PM by ahcho

    Finding a related column within a table

    ahcho

      Title

      Finding a related column within a table

      Post

      Hello!

      So here's my problem. I have a table that looks similar to this:

      NameScore

      Bob55

      Derek60

      Aaron45

      I want to be able to display the name of the person with the highest score. I can find the highest score by using the Max() function but how do I get the name to show up in a field?

      Aaron