How do I set up autonumber to start 001001 in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could someone please help me with this. I would like to set up Autonumber so
that it starts 001001. I notice that when I try to set this up to append a
query it deletes the first to digits. I would be very grateful if someone
could help me with this problem. Many thanks
 
An Autonumber is an integer. Numbers do not have leading zeros. Text can
have leading zeros. You can combine text and number field to display what
you are asking for.
There are schemes that will look for the highest value in a text field and
increment it. Search on incrementing text field.
 
Thank you for your help, this has answered my question and I appreciate your
help.
Many thanks
 
Thank you for your help with this issue. Your help is appreciated and has
solved my problem.
 
You must log in or register to reply here.

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

Copy worksheets and save files dynamically 3
Append query - Append to table with Autonumber field 2
Append to table with 2 fields in Primary Key - last is an autonumb 1
Update query with autonumber field 4
reset autonumber to '0' following delete query prior to appending 1
Append Query: SQL to add a new record? 7
Autonumber restarting after compact and repair 4
Access 2007 - append query only appending 0 rows??? 0

Back
Top