>>>Cetin,
>>>I guess it cannot be done!
>>>
>>>Peter
>>
>>?
>>Cetin
>This view is driving a form which has been in use for a long time.
>I need all fields.
>I guess it cannot be done in one sql statement anymore.
>
>I was hoping someone knows a trick...
>
>Peter

Peter,
Other fields only serve as nonreliable values (in VFP7 and prior last physical entry of group). If you need them, create one w/o them then join. Or fill them with dummy values just to satisfy controlsources. ie:

select a.GroupField, '' as Myfield1, sum(...) .... group by 1,2
Cetin