Query with autonumber

[Boon]

Hello,

I have table A that contains only 1 column. The column name is NAME.

I want to build a query that will give this result.

ID NAME
1 John
2 Tom
3 Mary
..
..
..
..




How can I do this in query. This is a simple example to illustrate what I
try to do. My final goal in my work is that I want to have coulmn ID as a
unique value. (like using autonumber in table). I think if I can get the row
number then I can add to some constant number (e.g. 100000) to get a final
ID number.

Thanks a lot.
Boon

 

[Allen Browne]

See:
Ranking or numbering records
at:
http://allenbrowne.com/ranking.html#query