---

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

This MSAccess tutorial explains how to create a random number field in a table in Access 2007 (with screenshots and step-by-step instructions).

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