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

How to I make my Autonumber field always begin with 1?

P: 39
I have figured out that there is no easy way to create an autonumber field in a query, but that there is a way (supposedly) to create an autonumber field in a table or rather, there is already an autonumber field (the ID field). Is there any way I can make this ID or autonumber field to always begin with 1 so that it acts as a sort of counter/sequential numbering field for the records I put into the table?

I am appending the records from a query of fields from another table in case that has anything to do with it.
Feb 25 '11 #1

✓ answered by TheSmileyCoder

Yes, I would normally do it in VBA. Im sure it could be done in SQL aswell, if one is more familiar with SQL.

Share this Question
Share on Google+
4 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
Autonumber fields reset to 1 when compacting (If table is empty)

Another option is to use code to delete the table, and then recreate it (using code)
Feb 25 '11 #2

P: 39
To delete the table and recreate it using code would I do that in VBA?
Feb 25 '11 #3

TheSmileyCoder
Expert Mod 100+
P: 2,321
Yes, I would normally do it in VBA. Im sure it could be done in SQL aswell, if one is more familiar with SQL.
Feb 25 '11 #4

P: 39
I figured it out, thanks! ................
Feb 25 '11 #5

Post your reply

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