• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

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?
0
jlcannon
Asked:
jlcannon
  • 4
  • 2
1 Solution
 
Brian PiercePhotographerCommented:
If your database is written properly then you shouldn't have to - can you give a little more detail
0
 
jlcannonAuthor Commented:
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.
0
 
Patrick MatthewsCommented:
jlcannon,

Out of curiosity, why does it matter?  An autonumber has no significance beyond providing a guaranteed-to-be-unique value.

Patrick
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
jlcannonAuthor Commented:
matthewspatrick, i feel the same way, however i was asked if it could be done this way.
0
 
Patrick MatthewsCommented:
Yes, you can insert with a specified value for the autonumber column, but IMHO you shouldn't, because the actual value of the autonumber is irrelevant and should not be invested with any semantic value.  Take that answer back :)
0
 
jlcannonAuthor Commented:
:P ill give that a shot but also, what would the insert into statement look like?
0
 
jlcannonAuthor Commented:
That worked for them and me Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now