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.
 
Back
Top