MS Access 2003: Create an auto-increment field in a table
This MSAccess tutorial explains how to create an auto-increment field in a table in Access 2003 (with screenshots and step-by-step instructions).
See solution in other versions of Access:
Question: In Microsoft Access 2003/XP/2000/97, how can I create a numeric field in a table that automatically increments?
Answer: To create a numeric field that automatically increments, you need to create an AutoNumber field. To do this, open your table in design view.
Create a new field in your table. Select the data type called "AutoNumber".
In the example below, we've created an AutoNumber field called SupplierID.
Advertisements