Last post Oct 17, 2016 07:58 AM by Parwaze
May 31, 2012 12:41 AM|TimoYang|LINK
I know that in SQL you can use Row_Number() function to generate 1~N since 2005, but in Access how？
Oct 17, 2016 07:58 AM|Parwaze|LINK
You can use AutoNumber. Go to create table design type the field name you want and select AutoNumber from Data type dropdown.
Additionally if you don't want to use duplicates choose no duplicate in fields properties > general tab > indexed