title: Concatenate fields from one column in one table into a single, comma delimited value in another table
body: <p>Any help that can be provided to a Access and VB noob would be greatly appreciated.  What I'm trying to do is concatenate the values from one table and insert it as a comma delimited value into a field in another table.  I'm trying to take all the server names that are say Linux boxes and concatenate them into a different field.</p>
  
  <p>Table A looks like this</p>
  
  <pre><code>Machine Name | Zone   | Operating System
  ----------------------------------------
  Server01      Zone A    Linux
  Server02      Zone B    Linux
  Server03      Zone A    Windows
  Server04      Zone C    Windows
  Server05      Zone B    Solaris
  </code></pre>
  
  <p>Table B has the field I want to insert into: Affected_Machine_Names.</p>
  
  <p>Now, I've tried looking through the Concatenate/Coalesce posts, but the SQL view in Access doesn't like the Declare statements. My VB skills suck badly and I can't seem to get the code to work in VB for Applications.  Unfortunately, I can't get this database converted into our SQL farm cause I don't have a server available at the moment to host it.  </p>
  
  <p>Can anyone point me in the right direction?</p>