Cetin,

thanks for the 2 suggestions : I have considered this first one but I'll definitly try the 2nd one (select top 1) which seems do what I want.

Pascal.

BTW : do you know the toystore called Maxitoys in Izmir ?


>If you need absolutely max(),sum() etc then another workaround that comes to mind (test performance) :
>
>select myField1,myField2 from myTable into cursor crsDummy nofilter
>select max(myField1),myField2 from crsDummy group by ...
>
>Cetin