title: to calculate MAX , SUM, AVERAGE from several columns (fields) in ACCESS 2013
body: <p>I have the following table in access:</p>
  
  <pre><code>    entity ratingA ratingB ratingC 
      XYZ     0-100   0-100   0-100
      ABC     0-100   0-100   0-100
  </code></pre>
  
  <p>I need to get a query to do some simple aggregate functions (SUM, MAX, AVE) out of every 3 columns for each entity (fields: ratingA, ratingB, ratingC), but the builtin function only do this for one field at once, not for several fields/columns.</p>