Building a format Query

[ferrisj]

I have phone numbers that do not have any mask on them. I am trying to write a query that would make Phone #, 5555555555 into 555-555-5555. I did this a long time ago, and remember the field looking something like:

UPDATEPHONE: ([Phone],3) & "-" & ([Phone],3) & "-" & ([Phone,4])

THis of course does not work. Can someone help me with this.

 

[PHV]

Why not simply this ?
UPDATEPHONE: Format([Phone], "000-000-0000")
Or this ?
UPDATEPHONE: Left([Phone],3) & "-" & Mid([Phone],4,3) & "-" & Right([Phone,4])


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

Hi,

Format([Phone], "000-000-0000")

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}