Solved

ACCESS QUERRY HELP....

Posted on 2007-03-28
10
249 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

837 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