Need Help!!

[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

 

[Duane Hookom]

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.

 

[silent_wolf]

Thanks for the help!! I'll give it a try today, and let you know if I
get it to work.