>>>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.)

I did and it may work, not sure given some of the other posts, but I was able to fit Al's solution into my code within a couple minutes and it's very non-complex. It worked very well with what I needed and now I'm on my way to the next challange.