Changing Auto Number Series in Access

  • Thread starter Thread starter TGV
  • Start date Start date
T

TGV

I want to assign a auto sl no which should start from 122565 and it should
add 1 for the next records that is 122566, 122567 & 122567 like that.

Please guide me with step by step instructions because I don’t know access
that much.

Awaiting for your reply.

Thanks in advance.

TGV
 
Use an append query to insert a recrod iwth the autonumber 122564. Delete
the record. The next record will be the one you want (unless you compact the
database, which resets the seed.)

Details in:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Needed for Assigning of Hot Key For a Command Button In acces 1
changing start value in the auto number 4
Changing Primary Key 1
How to reset database auto number 3
Find Special Characters Using Function 8
Assign Default Filter In Access Form 2
Append Table - Auto Number Problem 3
Auto picking numbers 5

Back
Top