Well, since I had to rewrite something I redid the whole form from scratch and abandoned the view altogether. I put the stuff into the business object.

:-)


Thanks anyway


Peter

>>>>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