sql statement needed

I need a sql statment to run in my Access program as a Query that will review a column of IP numbers, and count the number of UNIQUE IP addresses found. More importantly, I also want a query that will allow me to count the IP's that have unique first 3 of 4 sets. In other words, if these IPs are in the list: [login to view URL] [login to view URL] [login to view URL] the query would count these as a total of 1 I would appreciate it if you could post the actual statement, and I'll accept the bid from whoever posts it first. I've attached a fragment of my Access database. I'm looking for the Query that will allow me to count, or pull, the IPs that are unique in 2 of 4 or more. ## Deliverables just the sql statment above ## Platform win/access 2000