need an aggregate function

[Guest]

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?

 

[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?

Use a query:

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


mfG
--> stefan <--