Mike,
GO TOP & GO BOTTOM use index, but GO nRecNo doesn't position the marker to relational Record Number but the exect one.
>In the help file it specifies that GO BOTTOM uses an index, I would think that they all do.
>
>
BOTTOM
>Positions the record pointer on the last record in the table. If the table has an ascending index in use, the last record is the record with the highest key value. If the index is in descending order, the last record is the record with the lowest key value. >
>>Hello all.
>>My co-worker and I have a bet that we would like for you all to help settle.
>>
>>When "Go MyRecordNo" is issued, is there an internal index at work to find the record?
>>
>>Thanks.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.