title: Newest Record from three tables grouped by supplier
body: <p>I need to create a list with records out of three tables (table 1/2/3) from by database (SQLServer). 
  The Goal is, that the date of the newest delivery of each supplier is listed in ACCESS.
  e.g.</p>
  
  <ul>
  <li>Supplier 1 | Date 1 </li>
  <li>Supplier 1 | Date 2 </li>
  <li>Supplier 1 | Date 3 </li>
  <li>Supplier 2 | Date 1</li>
  <li>Supplier 2 | Date 2</li>
  </ul>
  
  <p>will become</p>
  
  <ul>
  <li>Supplier 1 | Date 3 </li>
  <li>Supplier 2 | Date 2</li>
  </ul>
  
  <p>I was able to create the complete list, but can't find away to filter out the newest delivery dates. Here is my code so far:</p>
  
  <pre><code>stmt_frei_list = " SELECT MBS.PartID, MBS.Supplier, MBS.Freigabe, V.VerwendID, V.PartID, V.SupplierID, V.Date, " &amp; _
                  " SZ.SupplierID, SZ.Supplier " &amp; _
                  " FROM Table1 as MBS INNER JOIN Table2 as V ON MBS.PartID = V.PartID " &amp; _
                  " INNER JOIN Table3 AS SZ ON SZ.Supplier = MBS.Supplier AND V.SupplierID = SZ.SupplierID " &amp; _
                  " WHERE MBS.PartID = " &amp; id &amp; " " &amp; _
                  " ORDER BY V.Date DESC "
  </code></pre>
  
  <p>There where some hints in the forum, but I could not get it running. 
  Do you have any advice? Thank you very much in advance.
  - Eric</p>