title: Microsoft Access: How to convert number to string using update query?
body: <p>I have an integer field with numbers ranging from 1000 to 99999. I want to convert this number field to a 5-character text field. This means all 4 digit numbers will have 0 added in front when converted to text. Example: 1000 in integer must be converted to 01000, etc.</p>
  
  <p>How do I do this? Thanks.</p>