>>SELECT *, IncrementThisValueByOne FROM MyTable >>
>>MyFieldOne MyFieldTwo IncrementThisValueByOne >> >>Bobby Jones 1 >>Jamie Lee 2 >>Terry Hatcher 3 >>
>select MyField1, myField2, recno() from (select myField1, myField2 from myTable...)