This thing works fine in VFP 7 when i try to execute it, but in version 9 it
gives me an error GROUP By clause missing or invalid. Anything im missing
here?

SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart,
military2 as tEnd,orno as Croom, ;
cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as
cdsc,CRANGGRPID as rangegroupid ;
FROM staffdtl ;
WHERE staffid = "XXX" ;
GROUP BY CRANGGRPID ;
ORDER BY dDateStart, dDateEnd, itimeStart, itimeEnd ;
INTO CURSOR cTest

TIA!

Nevermind.. I found it already.

http://support.microsoft.com/default.aspx?scid=kb;en-us;813361&Product=Vfp8