Auto number command ddl script access 2007

Asked By 30 points N/A Posted on -

Hi there! Making my program using Access. I have some issue on how making an auto number ddl script access 2007 Edition. What command should I use? Thanks guys indeed.

Answered By 30 points N/A #134143

Auto number command ddl script access 2007

Hello Sandra,
There are 3 different ways to generate autonumbers in Access. The data type you need is called Counter and numbers can be generated as start value plus increment, random numbers or replication IDs.
To create an autonumber field with a start value plus the increment you should use the following DDL query:
   Field1 COUNTER ([beginning_number], [increment_number]),
Hope this helped.

Login/Register to Answer

Related Questions