Insert a Blank record in a table

[Ron]

I have created a table with 3000+ records many more will be added. I wish to
insert blank records in the table to add information I have missed. For
example 5 records between record 200 and 201.
In dbase you can insert a blank. Is this possible in access?

 

[Dennis]

You need to have an Indexed field set to Yes (No Duplicates) then you just
add the records at the end and next time you open the table, they will be in
the correct place.

 

[Ron]

Thanks Dennis
Problem with that is that the autonumbering does not match the indexed
table. I need to have record numbering to match my indexed file. I can delete
the Autonumber field and add a new field as a number field and then drag the
numbers down on the indexed table. Time consuming, there has to be a better
way?

 

[gls858]

Thanks Dennis
Problem with that is that the autonumbering does not match the indexed
table. I need to have record numbering to match my indexed file. I can delete
the Autonumber field and add a new field as a number field and then drag the
numbers down on the indexed table. Time consuming, there has to be a better
way?

:

A table is just a bunch of records in no particular order. You just add
records as needed and do the sorting and grouping with a query. If you used
autonumber as a field to be used say as a customer number or an invoice
number, then you have a design flaw. Access isn't like Excel. The
autonumber field is only to insure that each record has a unique identifier.

gls858