How to Generate a Custom AutoNumber in MS Access?

By this video you can know how you can 'Start' AutoNumber field in Microsoft Access with your desired value and you can also control its increment.

Code Line:

"
ALTER TABLE [TABLE1]
ALTER COLUMN [Id] COUNTER (1,1)
"

[jloo]

Brilliant. Simple yet most effective, thank you!

[Initial_Gain]

Thank you very much as you gave me a solution to my problem. Sometimes when I opened my database and went to make a new entry it forgot the last record number in the AutoNumber column and tried to start with a previous AutoNumber that had already been filled. It then wouldn't enter the entry because of No Duplicates and I had no way to reset the counter with the next number as should... thanks...

[nataliyashtym]

Is there anything different I need to do in Access 2016? I'm following the exact steps but it's not working.

[ENGFREEMAN]

Thanks, please can we add test to number value, to make a professional ID counter.... Regards

[AD]

great class, how can I reset back to 1 ?

[rosdibinahmad]

what will happen to the ID/auto increment field when you compact and repair databases

[wehbiwehbi]

i have in ms access problem which it is that resultant table not allowed to have more than auto number field so what i can do?

[jcchanliu]

How to do a letter increment from A to Z?