title: How to Sum Up Records in Multiple Columns in MS Access Table
body: <p>I have a table of Accruals by Month, with each Accrual in a separate row and the months across the top like the below. </p>
  
  <p>There are also some non-numerical columns in the table such as Reference and Company as per the below. </p>
  
  <pre><code>              Jan-16   Feb-16  Mar-16 Reference Company   Total 
  Accrual 1      $100    $200    $300       x        Z      $600  
  Accrual 2      $150    $450    $550       y        A      $1,150 
  Accrual 3
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/nsic7.jpg" rel="nofollow noreferrer">Screenshot of Image</a></p>
  
  <p>I want to put a Total Column at the end of the table that sums up all the monthly entries for each Accrual. </p>
  
  <p>Bearing in mind that the number of monthly columns will increase by 1 each month and I don't want to have to manually change the formula to add the new month in each month.</p>
  
  <p>Would be grateful for ideas on how to do this please?</p>
  
  <p>Thanks </p>