Source Count-small prob

Jan 20 2009 10:26 AM

Hai all........

In my dataset i have a column called Source IP addr......which contains IP addr as its values.....

ex:

204.71.200.244
135.8.60.182
204.71.200.244
172.16.115.5
135.8.60.182
196.37.75.158
172.16.115.5
135.8.60.182
204.71.200.244
135.8.60.182
196.37.75.158

Now my goal is to calculate no of occurences of each ip addr..that is..My output should be...for ex...

193.37.75.158 2
204.71.200.244 3

Hope u got it.....

Any help.........in the logic ..........

Answers (3)

RAISEERROR problem

Access DataBase