Hi i'm pretty new to Access and i have just recieved a telemartketers phone list in access.
Now i already have a way to use this information but i need to split the phone numbers from the area codes.
what i have is (03) 9873 3857 in one field but i need the area code in a seperate field
eg...
Hi i'm pretty new to Access and i have just recieved a telemartketers phone list in access.
Now i already have a way to use this information but i need to split the phone numbers from the area codes
what i have is (03) 9873 3857 in one field but i need the area code in a seperate field eg...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.