>>>What if there were 10 fields in teh select statement, has a Group By clause, and no aggregate functions. Should all the 10 fields be identified in the Group By clause, and in the order of how they should be grouped?
>>>
>>
>>Henry,
>>
>>The order of columns in GROUP BY clause has no effect on grouping result.
>
>Oh - thanks Sergey. I was wondering about that because Mark advised that all non-aggregate fields should be included in the Group By clause, regardless of how many fields there are in teh select statement.
>
>Is there a way of doing a find in a development directory that would go into every form, prg and frx files to see where all the Group By caluses exist?
>

Yep. Go to Tools -> Code Reference.