>I have a table many records
>
>
>
>Name
>
>Jonh
>Jonh
>Jonh
>Jonh
>Albert
>Jonh
>Jonh
>Albert
>Moses
>Moses
>
>I want to summarize it to a new table, the name would appear
>only once and a new fiel counts how many times the name occours
>
>Name ========= occours
>
>Jonh ====== 6
>Albert ====== 2
>Moses ====== 2
SELECT Name,COUNT(*) AS Occours FROM Customers GROUP BY 1 INTO TABLE D:\MyTable.dbf
You can also UPPER(Name) AS Name as the first field if you wish to get that variation as well.