Help with SQL Query

  • Thread starter Thread starter Tom Bruce
  • Start date Start date
T

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
 
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.
 
Use a Totals (Group By) Query:

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