Append Query

  • Thread starter Thread starter rainier000
  • Start date Start date
R

rainier000

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
 
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!
 
Back
Top