Need Help!!

  • Thread starter Thread starter silent_wolf
  • Start date Start date
S

silent_wolf

I obtained a list of approximately 500,000 phone numbers for work.
However, the problem is that the list of phone numbers have some agency
code in front of it. I need to create a query to get rid of the digits
in front of it. I'm really stumped on it. Here is an example of the
current date:

145213165555555
[14521] = the agency code
[3165555555] = phone number

What I need:

3165555555

So, you can see that I need to get rid of the first 5 digits. Any help
you can give you would much appreciated.

Thanks,

Silent_Wolf
 
You can use Mid([PhoneNumber],6) to get the characters beginning with the
6th. You can use an update query to update your actual field values. I would
make a backup of the table or mdb file prior to do any mass updating.
 
Thanks for the help!! I'll give it a try today, and let you know if I
get it to work.
 
Back
Top