title: Show only the most recent records and if they include a certain value
body: <p>I am trying to do the following:</p>
  <p>In access, I have a table like this:</p>
  <p><em><strong>customer table:</strong></em></p>
  <p><a href="https://i.stack.imgur.com/ZtgvY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZtgvY.png" alt="enter image description here" /></a></p>
  <p>And i´m trying to query the only the records with the most recent date, and if they have a value of 0.00EUR. If not, i don't want them to be displayed in the query.</p>
  <p>Can anyone share some information on how this can be achieved?</p>
  <p>Thank you so much.</p>