Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access SQL Query
Message
From
02/12/2005 09:34:23
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
Microsoft Office
Category:
Access
Title:
Access SQL Query
Miscellaneous
Thread ID:
01074196
Message ID:
01074196
Views:
44
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
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform