No, don't change the GROUP BY clauses...you need to determine if the fields that aren't in the group by clause are returning the correct information (for example, other fields could return correct information if they contain repeating information).
Does that make sense?
>
>Then then bset think its to locate all code where Group By clause appears and include all the fields in that table or cursor? Would that lead to moire problems, since once may be asking VFP to Group By many fields rather than 1 or 2 specific fields?
Steve Gibson