I am pulling sales data by part number.  I need to also retrieve (from a different table) the lsit price for each part number.  However the list price table contains multiple records for each part (our list prices get updated every year so there is an entry for 2011, 2010, etc).  I need to pull only the most recent price for each part.  My problem has been that not every part gets a new price every year (otherwise I could filter on effective price date > 12/31/2010), so the most recent price for 1 part might be 1/1/2011 while for the next part it might be 6/1/2009.  How can I pull only the  most recent list price based on effective date?

what happens if you create a maximum price formula ( presuming the price only increases and never decreases... you could create a group by date, group by day, and sort it so you get the max date.  if you place the amount in the date group does it successfully pull the max price as well???