are you looking at top 5 values for each year?then useSELECT *FROM(SELECT ROW_NUMBER() OVER (PARTITION BY YEAR(Table_PurchaseOrder_Information.CreatedDate) ORDER BY Table_PurchaseOrder_Information.CreatedDate DESC) AS Seq,Table_PurchaseOrder_Information.PO_Number, Table_PurchaseOrder_Information.Supplier, Table_PurchaseOrder_List.Unit_Price, Table_PurchaseOrder_Information.CreatedDateFROM Table_PurchaseOrder_Information INNER JOINTable_PurchaseOrder_List ON Table_PurchaseOrder_Information.ReferenceNumber = Table_PurchaseOrder_List.ReferenceNumber)tWHERE Seq<=5ORDER BY CreatedDate DESC
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/