title: How to add zeros in front of a text field in an access table
body: <p>I have an access table with a text field. It has alpha numeric values. But i want all values to be minimum 3 digit. so i want to add zeroes in front of all single or two digit values</p>
  
  <p>.</p>
  
  <pre><code>5  must become 005
  89 must become 089
  </code></pre>
  
  <p>how do i write a query to update all values in the table.</p>
  
  <p>thanks
  tksy</p>