reformatting phone number

[Jennifer]

I saw this in another thread but not sure where I would put this in my query.
I have phone numbers stored as text and when I run a certain query to export
I want it formatted this way.

Thanks!

Format([PhoneField],"(@@@) @@@-@@@@")

 

[Jerry Whittle]

Right up there in the Field row where PhoneField would normally go.

However Access will put an ugly Expr1 in the column heading when you run the
query. Put something in front of it like below to give the heading a little
more meaning.

ThePhoneField: Format([PhoneField],"(@@@) @@@-@@@@")