title: Find most recent price in price list
body: <p>I have a table with Item, Price and Price Date columns.  What I need to do is filter out only the old prices, showing only the most recent price for each item. I am using MS Access 2007 and need to reference the most updated price in some VBA I am writing, and in my research I cannot find a way to programmaticly access pivot table data for customer pricing elsewhere in the DB.</p>
  <h1>Example:</h1>
  <p>Table</p>
  <p>Item | Price | Price Date</p>