title: String concatenation in SQL statement VBA
body: <p>I am writing a SQL statement as a string in an access VBA macro.  I want to add a dynamic variable into the string statement but I am unsure how to concatenate it correctly.  Any help would be greatly appreciated.</p>
  
  <pre><code>"CREATE TABLE ThisTable " &amp; _
          "(StateMedicaid TEXT, Commercial TEXT, HIX TEXT, MMP TEXT, CMS Part D (CY " &amp; _ year " TEXT,  CMS Part D (CY " &amp; _ (year+1) " TEXT, );"
  </code></pre>