>I would like to know how i can get the record in a table with a certain value that is the maximum.

It's only necessary to post a message once in one area of UT; asking the same question in several places wastes time and effort, since rather than all answers to the question appearing in a single thread in a single forum, the potential answers get spread out, making it more difficult to track the responses. IAC, see my answer to this in the other place you posted the question.