title: I'm combining fields in an access query and I need the last number to show a certain number of digits
body: <p>Current code is:</p>
  
  <pre><code>[Plant] &amp; "" &amp; [CurrentYear] &amp; "" &amp; [CurrentMonth] &amp; "" &amp; [ID]
  </code></pre>
  
  <p>This gives me LO14A2, where <code>[Plant]=LO</code>, <code>[CurrentYear]=14</code>, <code>[CurrentMonth]=A</code>, <code>[ID]=2</code> but <code>[ID]</code> is supposed to be 00002. What should I have the format as?</p>