title: Sum Multiple Column MS Access Via Sql Query or VBA
body: <p>Problem:I am trying to make a Inventory Management Database on Microsoft Access 2010, and since i needed records date wise my Table looks like follows</p>
  
  <pre><code> SKU   2016-03-16   2016-03-17   2016-03-18   ...   Total
   AAA   10           -5           15           ...   20
   BBB   05           05           25           ...   35
   CCC   06           -5           24           ...   25
  </code></pre>
  
  <p>This way i wanted to add records for each day, but i am unable to make a "Total" column which will total all the columns (Sum(Columns*)) </p>
  
  <p>I am aware of sum and groupby but that works across multiple rows i am looking for something which can do the same for column</p>
  
  <p>Expected Solution: A way either by Sql Query or VBA to total all the columns for SKU AAA,BBB,CCC, if not possible to total in the same table then i am open to total the columns in a new table.</p>