I have a query where I want to display the column headings as row headings. Here is my query: Code:SELECT DISTINCTROW Avg(DateDiff(OrderDate, POItem.ReceivedDate)) AS AvgLeadTime, Min(DateDiff(Po.OrderDate, POItem.ReceivedDate)) AS MinLeadTime, Max(DateDiff(Po.OrderDate, POItem.ReceivedDate)) AS MaxLeadTime FROM Products INNER JOIN (POItem INNER JOIN PO ON POItem.PONo = PO.PONo) ON Products.ProductID = POItem.ProductID WHERE (((DateDiff(PO.OrderDate, POItem.ReceivedDate))>=1) AND (Products.VendorPart="7745k55")) GROUP BY Products.VendorPart;Any suggestions?
