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:

[url removed, login to view]

[url removed, login to view]

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

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Veja mais: php sql 2000, php statment, fragment, access sql query, sql query access, sql query access database, 100 engineering words, review 2000 words, count words php, access database sql, sql 2000, php count words, sql number, access sql count, sql access database, looking engineering post, column count php, list 2000 words, statement php, access 2003 sql 2000, access database needed, sql pull, query posts, program count numbers, sql unique bid

Acerca do Empregador:
( 114 comentários ) United States

ID do Projeto: #2996572

Concedido a:


See private message.

$2 USD em 1 dia
(75 Comentários)