I need to do an append query to get fix the numbering from
what is automated to what shows up in the record # box.
Is an append query the way to do this? I have a database
that the new autoformat # is 5 records off from the number
that says is my total records.

If not an append query, what else can I do to fix this?

You cannot modify the number in an autonumber field. If you've added then
deleted records from the table, the autonumber keeps going from where it
left off. Is this field linked to other tables, it wil lget tricky to
renumber it. If not then there are 2 choices.

1) If the autonumber is currently counting correctly for the records you
have and you only want the new records to autonumber correctly, compact the
database. This will reset the autonumber to start from the last number
showing and not the last number in its memory.

2) If you have missing numbers and want them all renumbered correctly, go
into the design mode for the table. Delete the field for the autonumber,
then add it back in. This will renumber everything.

Kelvin

"rainier000" <(E-Mail Removed)> wrote in message
news:031801c3aa18$004a1d20$(E-Mail Removed)...
> I need to do an append query to get fix the numbering from
> what is automated to what shows up in the record # box.
> Is an append query the way to do this? I have a database
> that the new autoformat # is 5 records off from the number
> that says is my total records.
>
> If not an append query, what else can I do to fix this?

THANK YOU! This worked. I had to delete all records that
were corrupt first and then I did the ID field deletion
and addition and recompacted and it is perfect!

Thanks again!
>-----Original Message-----
>You cannot modify the number in an autonumber field. If
you've added then
>deleted records from the table, the autonumber keeps
going from where it
>left off. Is this field linked to other tables, it wil
lget tricky to
>renumber it. If not then there are 2 choices.
>
>1) If the autonumber is currently counting correctly for
the records you
>have and you only want the new records to autonumber
correctly, compact the
>database. This will reset the autonumber to start from
the last number
>showing and not the last number in its memory.
>
>2) If you have missing numbers and want them all
renumbered correctly, go
>into the design mode for the table. Delete the field for
the autonumber,
>then add it back in. This will renumber everything.
>
>Kelvin
>
>"rainier000" <(E-Mail Removed)> wrote
in message
>news:031801c3aa18$004a1d20$(E-Mail Removed)...
>> I need to do an append query to get fix the numbering
from
>> what is automated to what shows up in the record # box.
>> Is an append query the way to do this? I have a
database
>> that the new autoformat # is 5 records off from the
number
>> that says is my total records.
>>
>> If not an append query, what else can I do to fix this?
>
>
>.
>