Timothy, et. al. (via Çetin)-

>
>>can you use the locate cmd to start at end of a dbf and proceed backwards?
>>
>>If you set your index descending yes :)
>>Cetin
>
>Something like (untested) :
>

>If val(sys(21))>0
> lcDescending = iif(descending(val(sys(21)),'myAlias'), ;
>	' ASCENDING ',' DESCENDING ')
> Set order to tag (order('myAlias')) &lcDescending
>endif
>

Please review this KB Article http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q165410 before using this technique. If you're depending on buffering and using a grid, this bug has the nasty side effect of not respecting the buffering let alone the data session.

In my case I found it worked to simply scan to find the previous value, but I had a guaranteed small data set.