How to create incremental Value returned by the query?

T

Tom

Hello,

How to return a column with the incremental value in the MS Access 97 query?

Basically, I want my results look like following:

RecID | FName | LName
1 | Ted | O'Connor
2 | Adam | Chalanger
3 | Ewa | Kowalski
.......


Any help is greatly appreciated,
Tom
 
Top