<div>
Convert it to a string. &nbsp;Concatenate 7 zeros on to the left of the string. &nbsp;Trim the string to only use the right 8 characters.<br />
<br />
Greg
</div>


Convert it to a string.  Concatenate 7 zeros on to the left of the string.  Trim the string to only use the right 8 characters.

Greg

<div>
right('00000000' + your_number,8)
</div>


<div>
In Your query<br />
<br />
Format (yourfield, &quot;00000000&quot;)
</div>


In Your query

Format (yourfield, "00000000")

<div>
ha, that's even nicer &nbsp;:)
</div>


<div>
<div class="content wysiwyg-content">
I have a list of ID numbers, what I need to do is add zeros to the front of the number for every number that is less than 8 digits. &nbsp;for example 123456 should be 00123456
</div>
</div>


I have a list of ID numbers, what I need to do is add zeros to the front of the number for every number that is less than 8 digits.  for example 123456 should be 00123456

query to add zeros to a number

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.