SELECT EmpID, MIN(TransDate) AS MinTransDate, MAX(TransDate) AS MaxTransDate
FROM YourTable
GROUP BY EmpID

quote:

---

Microsoft OLE DB Provider for SQL Server error '80040e14'

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

---

SELECT Schedule.Empid, Min(Schedule.TransDate) AS MinTransDate, Max(Schedule.TransDate) AS MaxTransDate, WorkOrder.Request  FROM Schedule INNER JOIN WorkOrder ON Schedule.WoNum = WorkOrder.WoNum  WHERE (((Schedule.WoNum) In (SELECT WoNum
FROM WorkOrder
WHERE ProjectId = 'MMColParam')))  GROUP BY Schedule.Empid, WorkOrder.Request;

SELECT Schedule.Empid, Schedule.TransDate, Min(Schedule.TransDate) AS MinTransDate, Max(Schedule.TransDate) AS MaxTransDate, convert(varchar(200), Request) AS Request   
FROM Schedule INNER JOIN WorkOrder ON Schedule.WoNum = WorkOrder.WoNum    
WHERE (((Schedule.WoNum) In (SELECT WoNum
                             FROM WorkOrder
                             WHERE ProjectId = 'MMColParam')))    
                             GROUP BY Schedule.Empid, convert(varchar(200), WorkOrder.Request), Schedule.TransDate
                             ORDER BY EmpID ASC, TransDate ASC