DUHHH !! It worked of course hehehe thanks
William

>What if you tack "DESC" to the end?
>
>>SELECT top 4 *;
>> FROM gmsheet1.dbf TEST;
>> ORDER BY ddate