How do I add "autonumber" to an existing Access database

C

carpqueen

I created a database of about 400 records and for some reason there is no
"autonumber." How do I add this feature to this database...and don't you
need an identifier (like autonumber) in order to do a query? I don't know
much about this software and am limping along...so I greatly appreciate any
help I can get!
 
D

David Billigmeier

Right click on your table and select "Design View". Then, enter a new field
(i.e. call it AutoNumberVar). Then, select "AutoNumber" for Data Type.

No, you don't need an identifier to run a query, only if you will be linking
2 tables together in that query do you need one.
 
X

xRoachx

The autonumber won't be added to your table automatically. To add it, create
a field with datatype Autonumber in the table where your records are at. This
should automatically create autonumbers 1-400 for your records.

But, as a suggestion I would read up on databases and relationships before
going further. Google the topics, including normalization, as well as search
through these forums for other documentation. Sorry I don't have any helpful
links for you but there are plenty of posts here.

I hope this helps at least a little. :)
 
Top