Access: Create an auto-increment field in a table in Access 2003/XP/2000/97

Also learn how to create an auto-increment field in a table in Access 2007.

Question:  In 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.