Changing a format

  • Thread starter Thread starter Sam Thurston
  • Start date Start date
S

Sam Thurston

Hello,

My coding skills are pretty minimal and have been told I
will need to write a module for my following problem.

My problem consists of telephone numbers in an incorrect
format within a table. An example of the current format
within the existing field is 546.432.5432 in need to
change this format to 1-546-432-5432 in a new field within
the same table. I have tried writing several update
queries to no avail. Can anyone help?

Thanks

Sam
 
What version of Access are you using? And what did you try for the
Update Query. If Access 2002 or Access 2003, you can set the Update To
to...
"1-" & Replace([TelephoneNumber],".","-")
 
Back
Top