[AccessD] A2003: Checking for dupe phone numbers

Darren DICK d.dick at uws.edu.au
Sun Dec 5 20:38:13 CST 2004


Hi Guys
I'm trying to comparing phone numbers and report dupes. 
 
Basically I get a user to enter a phone number - then check if it is already
in the dB 
If it is then I go to the record that already has it.
 
But of course people legitimately put in spaces after area codas and after
the prefixes.
So it becomes tricky to compare
 
eg 01 1234 5678 is the same number as 0112345678 but a simple dlookup won't
catch it
 
So I wanna remove all the spaces so I am comparing at least the same
'number'
 
OR
 
Do any of you have a method for comparing or routing out dupe phone
numbers??
 
Many thanks in advance
 
Darren



More information about the AccessD mailing list