I have this keeping track of ip addresses thing going. But how do you use distinct but add the rest of the fields that are not distict? Did that make sense? The other 2 fields i have are date and time. If i use distinct on them it wouldnt make a difference since your not going to have 2 people hit at the same exact millisecond(unless you serve millions and millions of hits daily then i suppose its possible)<BR><BR>recordset.open "SELECT DISTINCT ip FROM main", objConn<BR><BR>Matt