title: SQL ACCESS - select max(date) and corresponding value
body: <p>How can I get the corresponding value of MAX(date).
  Access it returns me an error when I select directly the column with the specified value.</p>
  
  <p>For example, I want to be shown only the line from the image.</p>
  
  <p>Thank you.</p>
  
  <p><img src="https://i.stack.imgur.com/PiCTJ.png" alt="enter image description here"></p>