Solved

ACCESS QUERRY HELP....

Posted on 2007-03-28
10
247 Views
Last Modified: 2010-08-05
Hello Access Experts.. I need a querry that will copy information out of one row and add it to another.
here is a sample of data that i want copy data from
ROW UserKeyin1  
lv=SC-ANNO-NOTE;co=4;lc=0;wt=2;place smartline;

I want the following data to be put in the ROW EXTRA_INFO
range:co=4;wt=2;lc=0;

Thanks
0
Comment
Question by:sherrick123
  • 5
  • 3
10 Comments
 
LVL 4

Expert Comment

by:mukhtar2t
ID: 18814759
insert into table yourtable (field1,field2,...) select field1,field2,... from anothor table where somecond
0
 

Author Comment

by:sherrick123
ID: 18816726
I dont thijnk all your answer made it through.  I don't see any sql to grab just the pieces of data i want out of one column and put it in another
0
 
LVL 4

Expert Comment

by:mukhtar2t
ID: 18816993
can you explaine more
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:sherrick123
ID: 18817220
i don't understand your answer.  
1) how would the querry look?
2) i create field 1 and field 2 as new rows in the table right?

Thanks
0
 
LVL 4

Expert Comment

by:mukhtar2t
ID: 18817254
The query copy the field1,field2 from atable into the corresponding tow fields on anothertable
0
 
LVL 4

Expert Comment

by:mukhtar2t
ID: 18817269
I can't understand what you want
- copy a row from table to table
or
copy a column to another column in the same table
0
 

Author Comment

by:sherrick123
ID: 18818447
I HAVE A field CALLED UserKeyin1  
Data in the field looks like this
lv=SC-ANNO-NOTE;co=4;lc=0;wt=2;place smartline;

I want to "strip out co=4;lc=0;wt=2 AND prepend it with the text "range:"
in the SAME TABLE the the field UserKeyin1 their is another field called
 ROW EXTRA_INFO
That is where i want the "stripped out" data to go
range:co=4;wt=2;lc=0;
 
does that help explain it better??

0
 
LVL 4

Accepted Solution

by:
mukhtar2t earned 500 total points
ID: 18828460
update
   your_table
set
  EXTRA_INFO =
    'range:' +
    mid(UserKeyin1,InStr(UserKeyin1,';')+1,InStrRev(UserKeyin1,';',len(UserKeyin1)-1) -InStr(UserKeyin1,';') -1)
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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