Query to return last PO for items ordered (1 Viewer)

[bryguy]

Hi all, I have been trying to do a query on a table in MS Access that will pull the latest purchase order for each stock code based upon last receipt date. I either get no results or every PO listed for the StockCode, instead of the latest one.

TableID: PurchaseOrdersMasterData
Field1: StockCode
Feild2: PurchaseOrder
Field3: LastReceiptDate

Any assistance is greatly appreciated.

 

[June7]

Could use a TOP N nested subquery. Review http://allenbrowne.com/subquery-01.html#TopN