>Getting frustrated with this... I usually can figure this stuff out but for some reason I am stumped on this one.
>
>I have a table (fax_data) that has a notes field in it. What I want to do is show the distinct values in the notes field, and show how many times that value appears. The distinct values are easy, but I was trying to use the count function to count how many times the value appears. If anybody can show me how to do the second part, that would be great.
>
>
>SELECT DISTINCT notes
>FROM dbo.fax_data
>
SELECT COUNT(*) AS NoteCnt,notes
FROM dbo.fax_data
GROUP BY notes