problem with autonumber field

[Faisal Sharif]

i want to change the starting value of the autonumber field to the value
that i want one way is the ubdate query .............
is there another way of changing the starting value
if there is , kindly inform me . thanks

 

[Guest]

Hi Faisal,

You can use data definition language for a new autonumber field, as in this
example:

http://support.microsoft.com/kb/202121/en-us


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Joseph Meehan]

i want to change the starting value of the autonumber field to the
value that i want one way is the ubdate query .............
is there another way of changing the starting value
if there is , kindly inform me . thanks

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.