reformatting phone number

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

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

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

News 419m phone numbers leaked in Facebook data breach 3
how to change format of data already entered 5
Append Query - key violation - no duplicates, records exist in par 4
Update query issue 0
Access Tidy up phone numbers 0
Fixed Numbers 3
formatting a phone number in a string 2
Formatting when working with phone numbers in queries 7

Back
Top