<div>
Try this<br />
<br />
=IIF(LEN( [PRWBBEPI]![FILE #]) =3,&quot;000&quot;&amp; [PRWBBEPI]![FILE #] ,IIF(LEN( [PRWBBEPI]![FILE #]) =4,&quot;00&quot;&amp; [PRWBBEPI]![FILE #] ,<br />
IIF(LEN( [PRWBBEPI]![FILE #]) =5,&quot;0&quot; &amp;&nbsp;[PRWBBEPI]![FILE #] , [PRWBBEPI]![FILE #])))<br />
<br />
Kelvin
</div>


Try this

=IIF(LEN( [PRWBBEPI]![FILE #]) =3,"000"& [PRWBBEPI]![FILE #] ,IIF(LEN( [PRWBBEPI]![FILE #]) =4,"00"& [PRWBBEPI]![FILE #] ,
IIF(LEN( [PRWBBEPI]![FILE #]) =5,"0" & [PRWBBEPI]![FILE #] , [PRWBBEPI]![FILE #])))

Kelvin

<div>
<div class="content wysiwyg-content">
I am trying to us this in an update Access query =IIF(LEN( [PRWBBEPI]![FILE #] =3,&quot;000&quot;&amp; [PRWBBEPI]![FILE #] ,IIF(LEN( [PRWBBEPI]![FILE #] =4,&quot;00&quot;&amp; [PRWBBEPI]![FILE #] ,<br />
IIF(LEN( [PRWBBEPI]![FILE #] =5,&quot;0&quot; &amp;&nbsp;[PRWBBEPI]![FILE #] , [PRWBBEPI]![FILE #])<br />
It keeps telling me wrong # of arguments Can anyone see where I went wrong
</div>
</div>


I am trying to us this in an update Access query =IIF(LEN( [PRWBBEPI]![FILE #] =3,"000"& [PRWBBEPI]![FILE #] ,IIF(LEN( [PRWBBEPI]![FILE #] =4,"00"& [PRWBBEPI]![FILE #] ,
IIF(LEN( [PRWBBEPI]![FILE #] =5,"0" & [PRWBBEPI]![FILE #] , [PRWBBEPI]![FILE #])
It keeps telling me wrong # of arguments Can anyone see where I went wrong

=IIF Query

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

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.