Jimi,

This should work for Fox2x tables also. Exactly how do you know what the "last" record is? By Date? Key value? Record number?

>Hi Garrett,
>
>Thanks for the reply, but how if my table is in fox2x format? I tried your suggestion but it still come out with the first match record..
>
>Please help! thanks a lot!
>
>
>>>hi all,
>>>
>>>I have this query:
>>>

>>>Select a, b, c from MyTable;
>>>  into array MyArray;
>>>  where a=MyKey
>>>

>>>
>>>If there are serveral matches in the table, how should I modify this query in
>>>order to get the last matched one?
>>
>>One way to do this would be to use the TOP 1 and the ORDER BY myField DESCENDING clauses.