<div>
That did the trick! &nbsp;Thank you so much; the answer had eluded me for several days.
</div>


That did the trick!  Thank you so much; the answer had eluded me for several days.

<div>
Then next time use EE sooner ;-)<br />
I personally stop working on a problem when it takes longer as one hour. Then it's time to ask a collegue (or EE)<br />
<br />
Success with the application !<br />
<br />
Nic;o)
</div>


Then next time use EE sooner ;-)
I personally stop working on a problem when it takes longer as one hour. Then it's time to ask a collegue (or EE)

Success with the application !

Nic;o)

<div>
<div class="content wysiwyg-content">
I am trying to write an update query that will convert all of my records in a field to 14 digits with leading zeros (0).<br />
<br />
So, instead of<br />
19750<br />
745513265<br />
<br />
I would like<br />
00000000019750<br />
00000745513265<br />
<br />
In Excel, I do it using =Rept(&quot;0&quot;,14-Len(B1))&amp; B1, but cannot figure out the syntax in Access.<br />
<br />
This must be simple, but I am tearing my hair out. &nbsp;Please help. &nbsp;Thanks.
</div>
</div>


I am trying to write an update query that will convert all of my records in a field to 14 digits with leading zeros (0).

So, instead of
19750
745513265

I would like
00000000019750
00000745513265

In Excel, I do it using =Rept("0",14-Len(B1))& B1, but cannot figure out the syntax in Access.

This must be simple, but I am tearing my hair out.  Please help.  Thanks.

Update Query - Pad String with Leading Zeros

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.