Converting telephone numbers

C

ChrisBat

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
 
J

John Nurick

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.
 

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

Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Inconsistent formatting of section numbers 0
convert columns to rows 6
Weekly Report 2
Converting data in column to Phone Format 1
Mail Merge and Access format of telephone number 2
Page numbering with Merged Document and IF statements 1

Top