Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Access SQL Query
Message
De
02/12/2005 09:34:23
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Titre:
Access SQL Query
Divers
Thread ID:
01074196
Message ID:
01074196
Vues:
43
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/
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform