Last Price for Part

You could determine the most recent selling price per part in a sub query (or two), then join the subquery into your top query.

Here’s a post detailing a similar problem/solution: