title: Group By and Count in Access
body: <p>I have this table in access and I'm trying to do a Count and a Group by but am getting an error. </p>
  
  <p><img src="https://i.stack.imgur.com/YFlKG.png" alt="enter image description here"></p>
  
  <p>What I'm trying to do is group by the source the number of cars which have AC and are made before 2008. </p>
  
  <p>I tried this:</p>
  
  <pre><code>SELECT SOURCE_ID, COUNT (SOURCE_ID) AS VEHICLES_WITH_AC
  FROM VEHICLE
  WHERE VEH_AC = 'Y'
  GROUP BY  SOURCE_ID, VEH_AC,  VEH_YEAR
  HAVING VEH_YEAR &lt;'2008';
  </code></pre>
  
  <p>But im getting: <img src="https://i.stack.imgur.com/ebcjx.png" alt="enter image description here"></p>