FahadTiger
Member
- Local time
- Today, 04:25
- Joined
- Jun 20, 2021
- Messages
- 115
Hello My Expert
I have tblPurchase with PurchaseID AS primary key and purchaseDate
and tblPurchaseDetail with PDID AS primary key and PurchaseID as number and ItemID AS number
and purchasePrice as currency...what I want the latest purchasePrice for each Item according to latest purchaseDate
any advise ...thank you
I have tblPurchase with PurchaseID AS primary key and purchaseDate
and tblPurchaseDetail with PDID AS primary key and PurchaseID as number and ItemID AS number
and purchasePrice as currency...what I want the latest purchasePrice for each Item according to latest purchaseDate
any advise ...thank you