Initializing Autonumerics values to 1 Lina Manjarres 17.08.2006 21:53:01 I need to have all my autonumeric values to start in 1. How can I do that? Thanks a lot, Lina

Re: Initializing Autonumerics values to 1 "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 18.08.2006 02:23:45 Hi, if your table have no records - then you can compact database in order to reset numbering to 1. Anyway - idea of autonumber field is to provide a unique number, and nobody should rely on it actual value. -- Best regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com "Lina Manjarres" <LinaManjarres[ at ]discussions.microsoft.com> wrote in message news:5E30DA22-9B18-40E5-BAAC-E114088559E4[ at ]microsoft.com... [Quoted Text] >I need to have all my autonumeric values to start in 1. > How can I do that? > > Thanks a lot, Lina

Re: Initializing Autonumerics values to 1 Lina Manjarres 18.08.2006 03:01:02 Thanks a lot. Why do you say I can't relay on the autonumber? "Alex Dybenko" wrote: [Quoted Text] > Hi, > if your table have no records - then you can compact database in order to > reset numbering to 1. > Anyway - idea of autonumber field is to provide a unique number, and nobody > should rely on it actual value. > > -- > Best regards, > ___________ > Alex Dybenko (MVP) > http://alexdyb.blogspot.com > http://www.PointLtd.com > > "Lina Manjarres" <LinaManjarres[ at ]discussions.microsoft.com> wrote in message > news:5E30DA22-9B18-40E5-BAAC-E114088559E4[ at ]microsoft.com... > >I need to have all my autonumeric values to start in 1. > > How can I do that? > > > > Thanks a lot, Lina > >

Re: Initializing Autonumerics values to 1 "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 18.08.2006 03:24:31 Hi, I mean that you can not be sure that it will be correct sequence, or next number will be last +1 If you need some meaning number, say order number, then you have to make your own function to generate such number and use a normal number field, long for example -- Best regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com "Lina Manjarres" <LinaManjarres[ at ]discussions.microsoft.com> wrote in message news:3D7122EF-72E5-411A-A313-0E1AFBEC8023[ at ]microsoft.com... [Quoted Text] > Thanks a lot. > Why do you say I can't relay on the autonumber? > > "Alex Dybenko" wrote: > >> Hi, >> if your table have no records - then you can compact database in order to >> reset numbering to 1. >> Anyway - idea of autonumber field is to provide a unique number, and >> nobody >> should rely on it actual value. >> >> -- >> Best regards, >> ___________ >> Alex Dybenko (MVP) >> http://alexdyb.blogspot.com >> http://www.PointLtd.com >> >> "Lina Manjarres" <LinaManjarres[ at ]discussions.microsoft.com> wrote in >> message >> news:5E30DA22-9B18-40E5-BAAC-E114088559E4[ at ]microsoft.com... >> >I need to have all my autonumeric values to start in 1. >> > How can I do that? >> > >> > Thanks a lot, Lina >> >>

Re: Initializing Autonumerics values to 1 Lina Manjarres 18.08.2006 14:07:30 Thanks a lot! "Alex Dybenko" wrote: [Quoted Text] > Hi, > I mean that you can not be sure that it will be correct sequence, or next > number will be last +1 > If you need some meaning number, say order number, then you have to make > your own function to generate such number and use a normal number field, > long for example > > -- > Best regards, > ___________ > Alex Dybenko (MVP) > http://alexdyb.blogspot.com > http://www.PointLtd.com > > > "Lina Manjarres" <LinaManjarres[ at ]discussions.microsoft.com> wrote in message > news:3D7122EF-72E5-411A-A313-0E1AFBEC8023[ at ]microsoft.com... > > Thanks a lot. > > Why do you say I can't relay on the autonumber? > > > > "Alex Dybenko" wrote: > > > >> Hi, > >> if your table have no records - then you can compact database in order to > >> reset numbering to 1. > >> Anyway - idea of autonumber field is to provide a unique number, and > >> nobody > >> should rely on it actual value. > >> > >> -- > >> Best regards, > >> ___________ > >> Alex Dybenko (MVP) > >> http://alexdyb.blogspot.com > >> http://www.PointLtd.com > >> > >> "Lina Manjarres" <LinaManjarres[ at ]discussions.microsoft.com> wrote in > >> message > >> news:5E30DA22-9B18-40E5-BAAC-E114088559E4[ at ]microsoft.com... > >> >I need to have all my autonumeric values to start in 1. > >> > How can I do that? > >> > > >> > Thanks a lot, Lina > >> > >> > >