Friends, I would like to find the vendor for the last time a part number was received and put it on a report. We can buy the same part from multiple vendors I just want the very last one. This query gets me that last receipt from each vendor.
SELECT [PO Receipts].PRTNUM_55, Last([PO Receipts].TNXDTE_55) AS LastOfTNXDTE_55, [PO Receipts].VENID_55
FROM [PO Receipts]
GROUP BY [PO Receipts].PRTNUM_55, [PO Receipts].VENID_55
ORDER BY [PO Receipts].PRTNUM_55;
I just want the vendor from the last receipt. How do I do that?
Doyce
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar