Query that creates autonumber ID field

[CharlesH]

Besides creating a new table and choosing the autonumber field, how do I create a query field that adds an ID number that automatically numbers itself (from 1,2,3,4,etc), when I query a table.

For example, I have a table with one field

Names
------
John
Frank
Larry

How do I create a query that numbers each record automatically? The query would be as follows:

ID Names
-- -----
1 John
2 Frank
3 Larry

Thanks for your attention.