auto number
in [Tables]
|
From: brian duffy on 27 Dec 2009 22:34 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
From: Allen Browne on 27 Dec 2009 22:53 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" <brian.bdit(a)gmail.com> wrote in message news:50cb7864-e200-462e-966e-15f44c0ad885(a)m25g2000yqc.googlegroups.com... > 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
From: MikeR on 28 Dec 2009 08:18 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
|
Pages: 1 Prev: Budget Table Next: How do I save the date a record was last modified in Access 2003 |