Basit Khan

Basit Khan

  • 1.3k
  • 336
  • 114.7k

How to get last purchase price depend upon date in MSAccess

Apr 27 2016 2:31 AM
Dear,
I have table called Trn_Purchase
fields are
ItemCode
ItemDesc
PurchaseDates
Price
I want to get the last purchase price depend on date
table have e.g below data
ItemCode PurchaseDate Price
A 01-Mar-2010 4
A 02-Mar-2011 6
 B 02-Mar-2015 2
 B 02-Mar-2013 10
then result should
itemCode PurchaseDate Price
A 02-Mar-2011 6
 B 02-Mar-2015 2
How to do this
Thanks
Basit.

Answers (3)