title: Average values in a column across several rows for each unique value in another column in MS Access
body: <p>I have query which produces a result like this:</p>
  
  <pre><code>ID | Area | Price
  1 | A | 10
  2 | A | 15
  3 | A | 10
  4 | B | 20
  5 | B | 15
  </code></pre>
  
  <p>The query linked two tables one with ID and Area, another with ID and Price. I want change my query to average the price field for each area so I would end up with:</p>
  
  <pre><code>Area | Price
  A | 11.6
  B | 17.5
  </code></pre>
  
  <p>I have multiple price fields which I would like to average in the same format. </p>
  
  <p>I'm using MS Access 2010.</p>