title: Reformatting a Phone Number in Access
body: <p>I'm in the process of uploading data into an access database, and some of the data has phone numbers listed in the format of <code>9999999999</code> and others are listed as <code>999-999-9999</code>. I would like for all the numbers to read <code>9999999999</code> so that way they can be cross referenced. I've been trying to run an update query on the numbers that are in the undesired format, but I am having no success. Blow is how I have the query set up:</p>
  
  <pre><code> Field: Wireless Number
   Table: Table to be updated
   Update to: Mid([Table].[Wireless Number],2,3)+Mid([Table].[Wireless Number],7,3)+Right([Table].[Wireless Number],4)
   Criteria: Not Like "**********"
  </code></pre>
  
  <p>Obviously, I'm not sure how to go about this, so that set up is a shot in the dark. What is the best way to go about getting the format that I need ?</p>