G
Guest
I would like to set a different number other than 1 as the autonumber.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Sorry, it is not possible. Autonumbers handle themselves.
L
Lynn Trapp
I'm not sure why it matters what the value of an autonumber field should be,
since the purpose of a unique identifier for a record that can be used to
join tables together. If the value matters, then you may want to consider a
different type of field.
If you are insistent on changing the seed value for your autonumber field,
though, you can run an insert query that sets the value of the field to 1
less than you want it to start with and then delete that record. For
example, if you want it to begin with 1001 then run the following query.
INSERT INTO YourTable (YourAutoNumberField)
VALUES (1000);
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
since the purpose of a unique identifier for a record that can be used to
join tables together. If the value matters, then you may want to consider a
different type of field.
If you are insistent on changing the seed value for your autonumber field,
though, you can run an insert query that sets the value of the field to 1
less than you want it to start with and then delete that record. For
example, if you want it to begin with 1001 then run the following query.
INSERT INTO YourTable (YourAutoNumberField)
VALUES (1000);
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html