Microsoft Access (Find Duplicate Query Str)

[visualkid]

Guys ,

currently i got a table named "Searchonly" with a field named "Searchstr"..... this field store all the search term that the user key in ....... whenever they perform a search

what i want is that, i want to have a query str that can return me the following information

Searchstr | Counter
-------------------------
a | 5
b | 20
c | 60


Note : counter is used to identify the number of same str appeared in that table....... Please help

 

[pharcyder]

Hi, try this:

[tt]
select Searchstr, count(Searchstr) as Counter
from Searchonly
group by Searchstr
[/tt]

Greetings from Germany,
Jens K.