jlcannon
asked on
Append records into access table between existing records,
I have an existing access table and I want to write an append query but i want to add these records between other records. I have them with record IDs so lets say i have records 1 -250 and I want to insert records at 25 how would i do that?
Brian Pierce
If your database is written properly then you shouldn't have to - can you give a little more detail
ASKER
ok I have a table that has a fields called ID and I have it set to auto number so everytime a record is entered it increases by 1. I just found several records that were misplaced and i would like to get them in the database table in the proper order and to do that just an append will not work. I want to append them to a specific row. for instand I want in insert a record at 25 and thus making the current record 25 record 26 and the new roecord I am appending 25.
jlcannon,
Out of curiosity, why does it matter? An autonumber has no significance beyond providing a guaranteed-to-be-unique value.
Patrick
Out of curiosity, why does it matter? An autonumber has no significance beyond providing a guaranteed-to-be-unique value.
Patrick
ASKER
matthewspatrick, i feel the same way, however i was asked if it could be done this way.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
:P ill give that a shot but also, what would the insert into statement look like?
ASKER
That worked for them and me Thanks.