>>Hi Robert and Wayne,
>>
>>>Is the last record deleted?
>>
>>or is there a filter or order set?
>No filter is set, but I do have the file indexed....
If the file is indexed, the physical last record of the file might well not be the last record according to the index order. The record number isn't a good indication of the end of file condition.
It could also be a corrupted index - try rebuilding the index file.