By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,011 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Want to generate a serial number using either query or VBA

P: 3
Hi
I am using ms access 2013. Often in my organization an excel sheet with the data needs to be imported in ms access for official use. While creating reports before that i want a table to have a serial number.So i add a field in the working table but i cannot populate the rows with serial number say starting from 1 2 3 4 5 6 .......100.
I have to populate it manually. Now the case came that it has 84000 rows. so i cannot insert it manually. Can some one tell me a query or VBA code to insert it.
Regards
Jan 14 '16 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,349
Add an autonumber field to the table.
Jan 14 '16 #2

P: 3
Waaaaw! thank you Rabbit. It worked!
Jan 15 '16 #3

Post your reply

Sign in to post your reply or Sign up for a free account.