>Hi to all:
>I don't understand how to write the group by clause in vfp8, naming all the fields? why? It's a big job!
>Anybody can give me an explanation?
>Thanks

Pedro,
In previous version of VFP, if you did not specify a field in the Group By clause, VFP would use the value associated with the record that occured last physically in the table. If you sorted the same table or packed it, you could end up with the same query returning two different results. This was considered to be a bug and was corrected in VFP 8.

If you don't care what values wind up in the extra columns, then don't include them in the query. This will decrease the number of fields you need to add in the Group By clause.

Regards.