Looking up the highest values.

[Shotodru]

Dear Friends,
I have a table containing a large number of names alongwith corresponding
balances. The names and the respective balances are of course in two
distinctly separate fields alongwith an unique (Primary Keyed) code field.

I wish to lookup the highest balances alongwith their respective names. I
know it is possible to obtain the highest/maximum value by using the DMAX
command. But how does one go about obtaining more than one record which
command the highest/maximum values. Also, how do I correspondingly get the
respective names.

Any suggestions would be most helpful.\

Best regards,
Satadru.

 

[Joseph Meehan]

Dear Friends,
I have a table containing a large number of names alongwith
corresponding balances. The names and the respective balances are of
course in two distinctly separate fields alongwith an unique (Primary
Keyed) code field.

I wish to lookup the highest balances alongwith their respective
names. I know it is possible to obtain the highest/maximum value by
using the DMAX command. But how does one go about obtaining more than
one record which command the highest/maximum values. Also, how do I
correspondingly get the respective names.

Any suggestions would be most helpful.\

Best regards,
Satadru.

I tend to just sort them by the value.