Formatting query output for phone number

[johnkrytus]

Will someone tell me what's wrong with the syntax of the format portion of this? please?
I copied >>> !\(999") "000\-0000;;_ <<< from the properties dropdown and am guessing therein lies my problem.

SELECT [FirstName] & " " & [LastName] & ", Supervisor" & "  " & Format([ContactNo1] "!\(999") "000\-0000;;_" AS exp, people.EmployeeID
FROM people;

 

[CJ_London]

you are missing a comma before and a bracket after your format string

 

[johnkrytus]

Thanks for the hint. I needed the comma. And the end bracket had been in so many places that it just got misplaced in the end.

I fixed it by getting away from the stupid wizard generated string

SELECT [FirstName] & " " & [LastName] & ", Supervisor" & "  " & Format( [ContactNo1], "(000)000-0000") AS exp, people.EmployeeID
FROM people;