>Erik,
>
>Thank your for the response to the question. I'm sure it will help me. However, there's a little problem. When I run the funtion, an error pops up saying "Cannot Group By Aggregate field."
>
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.
Erik Moore
Clientelligence