reformatting phone number



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.


Format([PhoneField],"(@@@) @@@[email protected]@@@")



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],"(@@@) @@@[email protected]@@@")

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