title: Access - Only take row from table of max year
body: <p>I have a table in Access that holds students previous qualifications. It has multiple lines per students dependent on the number of previous qualifications they have. The data has the year of the qualification in it.</p>
  
  <p>I want to create a sub-query that only has the most recent qualification in it (i.e. the latest year). I have tried <code>max</code> and <code>last</code> in the query for the year, but because I am bringing out other fields, it is still pulling out all the qualifications rather than just the latest one.</p>
  
  <pre><code>StudentID     Qualificationlevel    QualificationType   MaxOfYearAwarded
  
  10203         Postgraduate/Masters          MSc                2016
  10203         Undergraduate                 BSc                2013
  </code></pre>
  
  <p>So in the example above, I want to ONLY have the top row being pulled as it is 2016 and therefore later than 2013.</p>
  
  <p>Any help would be appreciated.</p>