hi all !!

i need to have an auto number in a new table but i need the auto
number to start from a certain number not zero.
how can i do this ??? any help would be appreciated !

thanks

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"brian duffy" <(E-Mail Removed)> wrote in message
news:50cb7864-e200-462e-966e-(E-Mail Removed)...
> hi all !!
>
> i need to have an auto number in a new table but i need the auto
> number to start from a certain number not zero.
> how can i do this ??? any help would be appreciated !
>
> thanks

brian duffy wrote:
> hi all !!
>
> i need to have an auto number in a new table but i need the auto
> number to start from a certain number not zero.
> how can i do this ??? any help would be appreciated !
>
> thanks

It sounds like you are planning to use the autonumber for something other than a
unique ID. If so, that's a mistake. Autonumbers are not guaranteed to be sequential,
aren't meant for human consumption, nor should they be manipulated.

Mike