If you had the IP 194.10.10.10
IP = "194.10.10.10"
stuck it in this
newIP = left(IP,InstrRev(IP, ".")-1)
then it would return 194.10.10 which you could then check against...
So i think if you did
if left(rsAM("AU_IP"),InstrRev(rsAM("AU_IP"), ".")-1) = "194.10.10" then
it would work
Does that make sense?
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk