Looking up the highest values.

S

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.
 
Top