[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

ACCESS QUERRY HELP....

Posted on 2007-03-28
10
Medium Priority
?
255 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
[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
  • 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 

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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

656 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