A rerquirement like that usually indicates a problem in design of data structures or application. The last record shoul be defined in terms of data stored in it, if such determination is necessary.

>best way to locate last record.
>
>i want find last record and want to update
>

>WHERE RECCOUNT()=RECNO()
>

>please tell me if any more best way
>thanks