 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Conversion / November 2003Converting telephone numbers
Hi, I have a 2 lists of telephone numbers - one that is in the form 4165551234, and the other that has the format 416 555 1234. I need to convert these to the same format, and cannot (unfortunately) do it through Excel as I have more rows of data in my database than are allowed in Excel. I'm using Access 97 if that makes a difference. Any suggestions would be appreciated. Thanks, Chris Hi Chris, You can do this with an update query. Set a criterion on the phone number field of Like "##########" (that's ten hash signs) and update it to Format([XXX], "000 000 0000") where XXX is the name of the field. >Hi, > [quoted text clipped - 7 lines] >Thanks, >Chris -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.