>>>Hi All,
>>> Is there a way to craft a select statement to list what is in a field and how many times what is in the field repeat?
>>>Thanks,
>>

SELECT field1, COUNT(*) FROM mytable GROUP BY 1

>
>Thanks Sergey, you are the greatest.

Note, that starting with VFP3, COUNT(myField) tells you the number of records in your group with a non-NULL value for myField, while COUNT(*) will bring the number of records in the group. YMMV.