>Hello everybody!
>
>Is there any way using one select statement get as result a top, let's say 10 MAX() values from field ?
>Thank's.
If I understand you right,
SELECT TOP 10 * FROM myTable ORDER BY myField DESC
should do it.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison