I am appending one table to another. The autonumber field in table1 ends at
989. When I append the second table's records, it jumps the number from 989
to 575272. Why does it do that and not just number the next appended record
990?

hi,

MTSmith wrote:
> I am appending one table to another. The autonumber field in table1 ends at
> 989. When I append the second table's records, it jumps the number from 989
> to 575272. Why does it do that and not just number the next appended record
> 990?
Autonumber fields are not designed to be sequences with out gaps. They
only ensure that you'll get a unique number. When using a sequential
autonumber, the default, then it guarantees that you'll get a strictliy
increasing number (Caveat: sign flip at 2^32-1).


mfG
--> stefan <--

"MTSmith" <(E-Mail Removed)> wrote in message
news:B215F60E-35E4-4C7E-AC18-(E-Mail Removed)...
>I am appending one table to another. The autonumber field in table1 ends
>at
> 989. When I append the second table's records, it jumps the number from
> 989
> to 575272. Why does it do that and not just number the next appended
> record
> 990?

AutoNaumbers are for internal indexing purposes only and it's value should
be of no consequence to the user. If you want sequential numbering then
you'll have to do that yourself.

Keith.

I don't know but autonumbers are guaranteed to be unique, beyond that is not
guaranteed. You cannot assume they will be sequential.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"MTSmith" wrote:

> I am appending one table to another. The autonumber field in table1 ends at
> 989. When I append the second table's records, it jumps the number from 989
> to 575272. Why does it do that and not just number the next appended record
> 990?

MT -

In your append query, are you including a field from the second table to go
into the 'autonumber' field in table1? If so, you should not have included
that field in your append query.

--
Daryl S


"MTSmith" wrote:

> I am appending one table to another. The autonumber field in table1 ends at
> 989. When I append the second table's records, it jumps the number from 989
> to 575272. Why does it do that and not just number the next appended record
> 990?

I may have done that. I'll check that out. Thanks for your input!
Terry

"Daryl S" wrote:

> MT -
>
> In your append query, are you including a field from the second table to go
> into the 'autonumber' field in table1? If so, you should not have included
> that field in your append query.
>
> --
> Daryl S
>
>
> "MTSmith" wrote:
>
> > I am appending one table to another. The autonumber field in table1 ends at
> > 989. When I append the second table's records, it jumps the number from 989
> > to 575272. Why does it do that and not just number the next appended record
> > 990?