Please forgive me, I don't have VFP8 yet. Simply adding extra1 to the group causes the query to return 4 records, correct? That's really not an acceptable end result for this type of query.
>
>In VFP 8 you would have to include extra1 in the group by because the result for extra1 is not clearly known to the computer. All values from extra1 appear to IMO remind you to think about which one you wanted.
>
Steve Gibson