>Sorry Cetin,
>
>with a index the solution is simple ( i read you message too fast ).
>( The strange thing is that a solution of this type i had used it time ago in one SELECT TOP 3 .. ORDER BY NULL DESC, but the memory .... ).
>
>Then,
>SET FILTER .. GO BOTTOM it is the only solution (except a cycle SKIP -1) without an index, or not ?
>
>Fabio
I see.
Set filter .. go bottom is a solution but not the only solution w/o an index.
ie:
select recno() as rcno ;
from myTable ;
where FilterCondition ;
order by myOrder descending ;
into array arrRecs
lnMatch = _Tally
go arrRecs[1]
and others exist I believe:)
Cetin