Create Index autonumber

[Guest]

I have a table

Name CodeQuestion Mark
..... ........... .....

I want insert 1 column index autonumber by query please help me!

ex

Index Name CodeQuestion Mark
1
2
3
4
....

 

[Allen Browne]

You do not need to assign a value to the autonumber. Access will give it the
next number automatically.

Note that INDEX is a reserved word in JET, SQL Server, and in ODBC, so not a
good choice for a field name. Likewise, nearly everything in Access has a
Name property, so if you use this query's results in a form or report, you
will run into problems.

Perhaps you just used those names as examples, but it is worth keeping in
mind. Here's a list of the words it is wise to avoid:
Problem names and reserved words in Access
at:
http://allenbrowne.com/AppIssueBadWord.html