Thanks Jason,
I think I have a good start with the nested recordset and Count function.
I'm having trouble with what to use for the WHERE clause in the nested (Count) recordset.
Also, how can I prevent the repeating of the same kennel names, and lastly how can I sort on the Count column.
Here is the link: http://www.oldenglishsheepdogclubofamerica.org/top_kennels_WA.php and attached is the file.
Thanks,
Dennis