>Woops. That should read GROUP BY 2. You are grouping on the "field" created by the concatenation of these fields.
>
>>Also I do not understand the Sytax of the command "COUNT(*)" and I am unable to find that funtion in the Foxpro Online Help CD.
>>Can you tell me what that command is doing?
>
>COUNT() just counts the records in the group. COUNT(Field1) would do the same thing, but COUNT(*) just tells the reader that you don't care which field is being counted.
Thanks for the correction, that worked. I appreciate the help.
Elgin