Help with SQL Query

[Tom Bruce]

I have a MS Access database that contains a column of IP addresses in one of
the tables. I want to create a query that shows me the number of times each
ip address appears in the data. I want the ip number to appear once in the
result with another column that shows how many times it appears. What is
the SQL query that does this?

Thanks
Tom

 

[tomt]

Try using the Find Duplicates query wizard (one of the
choices when you click on New while in the query tab).

That will give you a count of your dupes.

 

[Van T. Dinh]

Use a Totals (Group By) Query:

SELECT T.[IPAddress], Count(T.[IPAddress])
FROM YourTable As T
GROUP BY [IPAddress]