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

In case if there're nulls in the field1 in some records

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

would produce incorrect result because the count for group field1=Null would show 0 regardless of how many records are in this group.