Hi Dean,

Your select is invalid because it doesn't specify from which record take values for c.h1psyr, c.h1psmo and c.h1psdy columns. VFP8 by default doesn't allow such selects. See references I provided in previous message for detailed explanations.

>
>The following select sql statement works under VFP6.0. But does not work in VFP8.0 w/ SP1.
>
>SELECT c.h1psyr, c.h1psmo, c.h1psdy, sum(c.h1ramt) as amt, u.u1name ;
> FROM userunit u, cscash01 c ;
> WHERE u.u1unit = c.h1unit ;
> INTO CURSOR ytdcoll ;
> ORDER BY 5 ;
> GROUP BY 5
>
>All the selected fields are simple character field except the SUM field which is a numberic field.
>
>I lost as to why it's not working in VFP8.0.
>
>
>>Dean,
>>
>>Never heard about such problem with grouping on date fields. Is it VFP8? If it's, take a look at help under Behavior Changes Since Visual FoxPro 7.0 and in INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #813361.
>>
>>
>>>I was doing some queries and I noticed that when one of the selected field is a date field, the GROUP BY statement gives an "invalid group by ..." error.
>>>