Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Append records into access table between existing records,

Posted on 2011-09-21
7
Medium Priority
?
153 Views
Last Modified: 2012-05-12
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
Comment
Question by:jlcannon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 70

Expert Comment

by:KCTS
ID: 36574498
If your database is written properly then you shouldn't have to - can you give a little more detail
0
 

Author Comment

by:jlcannon
ID: 36574542
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
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 36580690
jlcannon,

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

Patrick
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:jlcannon
ID: 36580736
matthewspatrick, i feel the same way, however i was asked if it could be done this way.
0
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 36580767
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
 

Author Comment

by:jlcannon
ID: 36580838
:P ill give that a shot but also, what would the insert into statement look like?
0
 

Author Closing Comment

by:jlcannon
ID: 36601382
That worked for them and me Thanks.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question