Reformat data in table

[Jason Morin]

I have a simple table with a column of phone numbers. Some
are of the format (888)123-4567 and some are of the format
888-123-4567. What would be the easiest way of re-
formating this column so that all phone numbers look like
(888)123-4567?
Thanks.
Jason
Access 2002, WinXP

 

[[MVP] S. Clark]

The Left, Mid, and Right functions allow you to manipulate strings. Use
them to assist with this task.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-