title: Is it possible to sum a expression column in access?
body: <p>I have a column in access I need to get the total of. When I try the below method in my query I get the error "You tried to execute a query that does not include the specified expression 'ID' as part of an aggregate function."</p>
  
  <pre><code>Expr1: Sum([Column1])
  </code></pre>
  
  <p>Edit my query:</p>
  
  <pre><code>SELECT tblTest.ID,Field1,Sum([Field1]) AS Expr1 From tblTest;
  </code></pre>