>>>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
if we go in that direction, how about..
GO TOP
SKIP 2
Matt McDonnell
...building a better mousetrap with moldy cheese...