problem:
How to define the initial value and step value of the Auto Number field? How to define the initial value and step value of the field to add fields? How to make the start value of the automatic add field of the deleted data to start re-starting?
Reply:
With the following statement, you can specify its starting value and step value when you build a table:
Create Table TBLNeworder2 (ORDERID AUTOINCREMENT (1000, 10), itemid long, Quantity Long You can also modify the next start value and step value with the following statement:
Alter Table TBLORDER ALTER COLUMN ORDERID Counter (2000, 50) To start:
Alter Table Tablename Alter Column ORDERID Counter (1) In the VBE interface:
DOCMD.RUNSQL "Alter Table Tablename ALTER Column OrderId Counter"