Would this be accurate if all I cared about was office?
select detail,noun,sum(price),sum(qty),office from s:bsyear01 group by office;



>Not so much incorrect data, as meaningless data. The fields not in the 'group by' clause are simply the information from the final record in the group. If that's what you wanted (for whatever reason), then the data was ok. If you thought you might be getting something else, then the data was misleading.
>
>Alan
>
>>That's kinda of discouraging(and confusing). I am supposed to think my sql select statements possibly returned incorrect data in vfp7?
>>
>>
>>
>>>It's documented in VFP8 help under Behavior Changes Since Visual FoxPro 7.0 and INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #813361.
>>>
>>>>This statement works in vfp 6 but not vfp 8.
>>>>Select detail,noun,sum(price),sum(quantity) from s:bsyear03 group by detail;
>>>>into cursor norton
>>>>
>>>>In vfp8 the error message is "SQL:GROUP BY clause is missing or invalid."
>>>>
>>>>shall I change my ways?