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],".","-")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing format 2
import multiple txt files in worksheet and formating 1
HDMI is a terrible format and I wish it never existed 2
How do I change table field properties in a macro? 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Access: Create a macro to format a table field to currency? 1
Macro or CODE to change data format in a table for user 3
change a text format to number format 6

Back
Top