The microsoft access 2016 data type of autonumber is used when there is a specific need for a free d.Data type of formatted Autonumber - Microsoft Community

Arami

What curious question

What nice phrase

Tosar

I thank for the information, now I will not commit such error.

And so too happens:)

Tesar

I apologise, but, in my opinion, you are mistaken. I can defend the position. Write to me in PM, we will talk.

Locate the first available empty row in the table design grid. In the Field Namefield, type a name, such as CustomerID. In the Data Typefield, click the drop-down arrow and click AutoNumber. Under Field Properties, in New Values, click Incrementto use incrementing numeric values for the primary key, or click Randomto use random numbers.

Bakus

Other variant is possible also

Oct 23,  · Access Tip: Using the AutoNumber Data Type in Access. The AutoNumber data type automatically generates a unique number for each record that’s added to a table, and is commonly used for primary key fields. Seldom, if ever, should the value of the AutoNumber field be shown to your database users. Nov 25,  · I need to know how to make a custom autonumber in this format: R R=Requisition. 12=Last two digits of Current Year. 07=Current Month. 24=Current Day. 00=Sequential Number. I have been to forum after forum and cannot get a clear understanding of how to create a custom autonumber in this format.