How to get last purchase price depend upon date in MSAccess

Dear,

 

if data something like this

 

Trn_Purchase2

Itemcode	PurchaseDate	Price
A	01/03/2010	4.000
A	02/03/2011	6.000
A	01/03/2010	4.000
A	02/03/2011	10.000
B	02/03/2015	2.000
B	02/03/2013	10.000
B	02/03/2015	2.000
B	02/03/2013	10.000

 

then what will be the query.

 

Thanks

Basit 

select p.ItemCode ,p.PurchaseDate,p.Price
from dbo.Trn_Purchase p
inner join (select ItemCode,max(PurchaseDate) as Maxdate
   from dbo.Trn_Purchase
   group by ItemCode) t
   on p.ItemCode = t.ItemCode and p.PurchaseDate = t.Maxdate