Hi Claude
Group by was changed in vfp8. You now have to specify all fields not part of udf in the group by area. If you do a search on vfp 8 changes, you can find more on this (If Sergey does not give you links shortly ;-) )

>Since I could not search for Group By (is there a way to do this) I searched of select group and could not find why the following syntax (which works in VFP 7 does not work in VFP 9.
>

>SELECT						;
>	piitems.clstkno ,			;
>	instock.cdescript ,			;
>	piitems.nreqqty AS nreqqty ,		;
>	piitems.cuomissu ,			;
>	instock.nqty ,				;
>	piitems.ddatestamp			;
>	FROM 	piitems , instock		;
>	WHERE 	piitems.ddatestamp = issueddate	;
>	AND ALLTRIM(UPPER(piitems.clstkno)) = 	;
>		ALLTRIM(UPPER(instock.cstkno))	;
>	AND piitems.csitecode = gcsitecode	;
>	ORDER BY piitems.clstkno  		;
>	GROUP BY piitems.clstkno		;
>	INTO CURSOR dailyissues
>

>I get an error message that "GROUP BY clause is missing or invalid (error 1807). The help file is not very helpful. I also tried "GROUP BY 1" and get the same error message. What am I missing.
>
>TIA