I'm developing a database using exisiting data from DBase tables. I have imported data into access table. The PIN number format is the primary key of table. I would like to be to add data using current PIN format. Last entry is 1172 and would like to know how to have the next entry have 1173. Hope this explains enough.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
RE: Access table problem
- Thread starter trinir
- Start date
I think you mean that you want to have the PIN field be an AutoNumber type.
Have a look at thread181-64510 for some ways to handle starting AutoNumber at a specific number. Try a search on "Autonumber" in the FAQS of all the Access forums on Tek-tips for some other tips and tricks.
Or, I've completely misunderstood the point of your question!!
Ron
Have a look at thread181-64510 for some ways to handle starting AutoNumber at a specific number. Try a search on "Autonumber" in the FAQS of all the Access forums on Tek-tips for some other tips and tricks.
Or, I've completely misunderstood the point of your question!!
Ron
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question