Query: Most recent record for unique combination of two fields in MS Access 2010
Try this:

SELECT  a.* INTO recent_data 
FROM primarytrafficcountdata a 
 INNER JOIN (SELECT section_id,MAX(date) AS maxdate 
              FROM primarytrafficcountdata 
              WHERE YEAR(date) &lt;= 2014 AND YEAR(date) &gt;= 2011 
             GROUP BY section_id) groupeda 
 ON (a.section_id = groupeda.section_id AND a.date = groupeda.maxdate);