>Group Bys don't work in SQL like they do in VFP. You have to list every field in the SELECT list in the Group By clause.

No, you only have to include NON AGREGATE fields in the group by.

BOb