need an aggregate function

J

jane

I have text values stored in a field in a table of about 200 records. Some
values repeat themselves often. Is there a quick way to find out which value
appears the most often?
 
S

Stefan Hoffmann

hi Jane,
I have text values stored in a field in a table of about 200 records. Some
values repeat themselves often. Is there a quick way to find out which value
appears the most often?
Click to expand...
Use a query:

SELECT yourField, Count(*)
FROM yourTable
GROUP BY yourField


mfG
--> stefan <--
 
Top