Hi Steve.

You're forgiven.

As to the query, you're correct. Adding extra1 to the group results in 4 records. Leaving it out of the group by will give one record, but how does the computer know what is the "correct" result for the field extra1?

>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.
>>