QUESTION: How to Create a Top 2 Values per Group Query in Access (Expert11)

How can I modify the below SQL View in msAccess so to limit the results to at least top 2 minimun values from Unit Cost. There are two tables Products and VendorXProduct which includes the offers from Vendors.

SELECT ProductT.ProductID, ProductT.ProductName, VendorXProductT.VendorID, VendorXProductT.UnitCost
FROM ProductT INNER JOIN VendorXProductT ON ProductT.ProductID = VendorXProductT.ProductID
ORDER BY ProductT.ProductID, VendorXProductT.UnitCost;

---

Reply from Alex Hedley:

You can use a TOP clause covered in Beginner Level 5

The MIN Function is covered in Access Expert Level 3