title: Access Select Max date with corresponding records
body: <p>I am trying to create a query that looks at the most recent date and return the corresponding values. Using the <code>max</code> function works only if I have the <code>hose part no</code> and <code>max inspection</code> columns and nothing else. Once I add in the <code>scrap amount</code> columns it duplicates the <code>hose part no</code> column. I only want one single record per hose part no.</p>
  
  <p>Below is an example of what is going on:</p>
  
  <p><code>Hose Part No Max Inspection Date scrapamt1 scrapamt2  scrapamt3 scrapamt4</code></p>
  
  <p><img src="https://i.stack.imgur.com/Zy0QZ.jpg" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/tISg4.jpg" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/rdGiv.jpg" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/8d9f3.jpg" alt="enter image description here"></p>