title: Update whole table with concatenated strings in ms access
body: <p>as the title says, in ms access, i´d like to update my whole table with concatenated strings that need to be inserted into a certain column.</p>
  
  <p>example:</p>
  
  <p>string=ice</p>
  
  <p>columnA | columnB </p>
  
  <p>berg | iceberg</p>
  
  <p>bomb | icebomb</p>
  
  <p>blob | iceblob</p>
  
  <p>so you see, i need to concatenate my string and columnA in order to insert all that into column b.</p>
  
  <p>i tried </p>
  
  <p>UPDATE mytable SET mytable.columnb = "ice" &amp; [mytable].[columna];</p>
  
  <p>but it does not work, meaning there are no results in the cells. there are no errors visible. also tried with CONCAT but did not work either.
  could you please assist?</p>