Just trying to pull records from a single table with multple change reocrds per item. I want the last change. Query pulls all records.
Select productkey, productcostcode, NewCostPrice, max(StartDate) from IC_ProductCostPriceChanges
where productkey = '4080'
group by productkey, productcostcode, NewCostPrice
productkey productcostcode NewCostPrice Date
4080 7 0.0001 8/4/2015 0:00
4080 7 10.549 8/13/2015 0:00
Have tried in Access as well same results.