>>Is there any way to find out what the offset of the current record is under the current index?
>>
>>For example I am trying to find out what the 3rd record is under a certain index for example
>>
>>Any help greatly appreciated.
>>
>>TIA
>>
>>Mike
>
>I have an idea:
>
>nRec = RECNO()
>COUNT ALL WHILE RECNO()nRec TO nOffset
>nOffset = nOffset + 1

select top 3 field1 from mytable where condition order by indexfield