SELECT Cl_Ref, MIN(R.Re_Time) ; FROM Referral R; WHERE BETWEEN(DTOS(R.Re_Date), "20010101", "20010201"); GROUP BY Cl_Ref, Re_Date INTO CURSOR Minimums NOFILTER SELECT *; FROM Referral; WHERE BETWEEN(DTOS(Re_Date), "20010101", "20010201"); AND Re_Time = (SELECT min_re_time ; FROM Minimums; WHERE Minimums.Cl_Ref = Referral.Cl_Ref) ORDER BY Cl_RefIf anyone can think of another way, please let me know.