>>Yes.
>>

>>select MyField1, myField2, recno() from (select myField1, myField2 from myTable...)

>>
>>That was a tip by Tamar Granor on the last NY User Group meeting.
>
>Ok, I simplified the issue, but there are multiple tables and JOINs. Seems to get confused then with RECNO().

Hi Jay,

Did you read my suggestion too quickly? I said, it can be done with derived table, e.g.

select *, recno() as myRec from (select * from Table1 inner join Table2 ... etc.)