Solved

ACCESS QUERRY HELP....

Posted on 2007-03-28
10
251 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

717 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