COUNT number of times text in records

[gator]

I have a field of names where there are multiple records of the same name. I
want to run a query on this showing a field of the name and a field of the
number of time it is listed in the dataset. What SQL will do this? I've
done it in Excel Pivot but I don't know how to convert it to SQL.

 

[gator]

something like......

TRANSFORM Count(Debits.[Name]) AS [CountOfName]
SELECT Debits.Name, Count(Debits.[Name]) AS NameTotal
FROM Debits
GROUP BY Debits.Name
PIVOT Debits.NameTotal;

.....this is as close as I can get but it doesn't work.

 

[gator]

the following SQL works, but it shows the Name as row header and field
header. I don't nee or want the field header....just the fields Name and
Total of Name......?

TRANSFORM Count(Debits.[Name]) AS [CountOfName]
SELECT Debits.Name, Count(Debits.[Name]) AS [Total Of Name]
FROM Debits
GROUP BY Debits.Name
PIVOT Debits.Name;

 

[gator]

never mind...I got it