>SELECT *, IncrementThisValueByOne FROM MyTable >>
>MyFieldOne MyFieldTwo IncrementThisValueByOne > >Bobby Jones 1 >Jamie Lee 2 >Terry Hatcher 3 >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.