<div>
I like to break these up into pairs on separate rows, then delete the carriage returns. &nbsp;It looks like you have the correct # of argumens, but need to use the AND in the first comparison, not the &amp;<br />
<br />
PastDueOrPendingSWITCH: Switch(<br />
[Due Date Per Docs]&lt;Date() AND Isnull([Completed]),&quot;Past Due&quot;, <br />
IsNull([Completed] AND [Due Date Per Docs]&lt;Date(),&quot;Pending&quot;, IsNotNull([Completed]),&quot;Co<wbr />mpleted&quot;,<br />
1=1,&quot;Other&quot;)
</div>


I like to break these up into pairs on separate rows, then delete the carriage returns.  It looks like you have the correct # of argumens, but need to use the AND in the first comparison, not the &

PastDueOrPendingSWITCH: Switch(
[Due Date Per Docs]<Date() AND Isnull([Completed]),"Past Due",
IsNull([Completed] AND [Due Date Per Docs]<Date(),"Pending", IsNotNull([Completed]),"Completed",
1=1,"Other")

<div>
Thank you Gustav. &nbsp; Thanks for pointing out that the first 2 tests were identical. &nbsp;<br />
<br />
Fyed: &nbsp;seems there was a wrong number of arguments
</div>


Thank you Gustav.   Thanks for pointing out that the first 2 tests were identical.  

Fyed:  seems there was a wrong number of arguments

<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
I was missing a ), but also didn't pick up on the fact that the first two were identical until after Gustav mentioned that.
</div>


I was missing a ), but also didn't pick up on the fact that the first two were identical until after Gustav mentioned that.

<div>
<div class="content wysiwyg-content">
Experts, I have a wrong number of arguments in this SWitch statement: <br />
<br />
PastDueOrPendingSWITCH: Switch([Due Date Per Docs]&lt;Date() &amp;&nbsp;Isnull([Completed]),&quot;Past Due&quot;, IsNull([Completed] and [Due Date Per Docs]&lt;Date(),&quot;Pending&quot;, IsNotNull([Completed]),&quot;Co<wbr />mpleted&quot;,1<wbr />=1,&quot;Other&quot;<wbr />)<br />
<br />
Not sure if &quot;IsNotNull&quot; is the issue. &nbsp;I also tried Nz([Completed]),&quot;&quot;)=&quot;&quot;. &nbsp;I imagine it is a comma or a parenth but I dont see it. <br />
<br />
thank you
</div>
</div>


Experts, I have a wrong number of arguments in this SWitch statement: 

PastDueOrPendingSWITCH: Switch([Due Date Per Docs]<Date() & Isnull([Completed]),"Past Due", IsNull([Completed] and [Due Date Per Docs]<Date(),"Pending", IsNotNull([Completed]),"Completed",1=1,"Other")

Not sure if "IsNotNull" is the issue.  I also tried Nz([Completed]),"")="".  I imagine it is a comma or a parenth but I dont see it. 

thank you

Switch error

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.