Access: Create a random number field in a table in Access 2007

Also learn how to create a random number field in a table in Access 2003/XP/2000/97.

Question:  In Access 2007, how can I create a numeric field in a table that is assigned a random number?

Answer:  To create a random number field, open your table in design view.

To do this, open your table in design view by right-clicking on the table name in the left window and selecting Design View from the popup menu.

Create a new field. In this example, we've created a field called Random_Value. Select "AutoNumber" as the data type.

Then in the General tab, set the "New Values" property to Random.