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