title: Copy and paste from one column to another in MS_Access
body: <p>Fellow overflowers,</p>
  
  <p>I am working with a database to sort several other databases and change some values so my scada application can use the values in the database.</p>
  
  <p>Now I have encountered the following problem:</p>
  
  <p>I have a column called "Name"  and in this column are string values like this one:</p>
  
  <pre><code>S1\SVS_AK\STS\Status[7]
  </code></pre>
  
  <p>From this string I'd like to cut (or copy, doesn't really make a difference eitherway) the "[7]" part and paste this behind whatever I have in a different column.</p>
  
  <p>So for example:</p>
  
  <p>I have a column "Address" and a column "Name"
  I want to take the [7] from the Name Column and paste that behind the already existing string "DB32,7.3" wich exists in the column Address</p>
  
  <p>How can I possibly do this? Preferably with a query</p>
  
  <p>Thanks in advance!</p>