You're welcome.

>Eurika!
>I see the errors of my ways.
>
>Thanks Sergey.
>
>
>>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.
>>>>>