Plamen,
On further investigation, it is not doing exactly as I want, if I do a select *. I want the Highest Flda RECORD returned

Flda Fldb Fldc Fldd Flde etc
A 100
A 300
A 150
B 500
B 800
B 600

If I Select SELECT *, MAX(Fldb) AS C FROM TempFile GROUP BY C, it returns

Flda Fldb C
A 150 300 Record no. 3 from File above
B 600 800 Record no. 6 from File above

What I want returned is:
A 300 Record no. 2 above
B 800 Record no. 5 above

The file above is just a sample for illustration purposes. I am reaaly in terested in the other fields that are in the file, and I need the record whch has the highest FldB value returned , for any of the records grouped by Flda.

Regards
Gerard









>Plamen,
>Thank you very much for your reply which works great
>
>Gerard
>
>