>Is there a way to have a value that increments by one in a SQL statement?
>
>

>SELECT *, IncrementThisValueByOne FROM MyTable
>

>
>To get:
>
>

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