 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / April 2008Increment AutoID staring with a number other then 1
Hi, Does anyone know how I can add an auto number to my existing table that would start with a number of then 1. For example 50, 51, 52 etc.. Thanks in advance for your help Try this. Start a new query in design view. Make it a make-table query. Go to sql view and type: alter table tablename add column id counter (1001,50) or wherever you want to start. Run the query. It should add that column to your table. > Hi, > Does anyone know how I can add an auto number to my existing table that would > start with a number of then 1. For example 50, 51, 52 etc.. > Thanks in advance for your help Why? If you are using an Access "Autonumber" field, they are designed to provide a unique row identifier. That's it. They really aren't fit for human consumption, so it probably doesn't matter what number they have. Why does it matter to you? Regards Jeff Boyce Microsoft Office/Access MVP > Hi, > Does anyone know how I can add an auto number to my existing table that > would > start with a number of then 1. For example 50, 51, 52 etc.. > Thanks in advance for your help |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.