>It depends on what result you want. Either remove 'DateRequired' from the ORDER BY because it's not a part of the result set, or change ORDER BY to

>ORDER BY 2,1	;
>

>
>

>>SELECT 	Customer.code, Min(Ordhead.daterequired),Max(Ordhead.daterequired) ;
>>FROM 	frantisi!ordhead, Customer ;
>>WHERE 	OrdHead.CustomerID= Customer.CustomerID	;
>>GROUP   BY customer.code ;
>>ORDER 	BY DateRequired	,Customer.Code	;
>>INTO	cursor	Temp
>

>>above query works fine in VFP7 but fails with "Order by clause is invalid"
>>
>>How do I fix it?
>>Mike


Thanks,
Mike