• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

ACCESS QUERRY HELP....

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
sherrick123
Asked:
sherrick123
  • 5
  • 3
1 Solution
 
mukhtar2tCommented:
insert into table yourtable (field1,field2,...) select field1,field2,... from anothor table where somecond
0
 
sherrick123Author Commented:
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
 
mukhtar2tCommented:
can you explaine more
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
sherrick123Author Commented:
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
 
mukhtar2tCommented:
The query copy the field1,field2 from atable into the corresponding tow fields on anothertable
0
 
mukhtar2tCommented:
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
 
sherrick123Author Commented:
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
 
mukhtar2tCommented:
update
   your_table
set
  EXTRA_INFO =
    'range:' +
    mid(UserKeyin1,InStr(UserKeyin1,';')+1,InStrRev(UserKeyin1,';',len(UserKeyin1)-1) -InStr(UserKeyin1,';') -1)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now