You must list all the fields in the select statement and include all also in the group by except for the agregates.

Select flda, Max(fldb) As Fldb, fldc, fldd.... From tempFile Group By Flda, fldc, fldd....

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