<div>
This is how Swich works:<br />

<pre><code id="code-20-42018824-1">Switch([CurrencyID]=1,[Gustav],[CurrencyID]=2,[Gustav]*[ExchangeRate])</code></pre>
It's basically like a one line Select Case statement.
</div>


This is how Swich works:


Switch([CurrencyID]=1,[Gustav],[CurrencyID]=2,[Gustav]*[ExchangeRate])

It's basically like a one line Select Case statement.

<div>
Thank you &nbsp;very much for your response.
</div>


<div>
or you could use it like:<br />
<br />
=Switch(NZ(Gustav],&quot;&quot;) = &quot;&quot;, &quot;O after pmt&quot;, [CurrencyID] = 1, [Gustav], True, [Gustav] * [ExchangeRage])<br />
<br />
I always finish out my SWITCH( ) function calls with a final pair that includes a TRUE and a value to use if none of the other conditions are met. &nbsp;This guarantees that if none of the original conditions are met, I will still get a value returned that I can filter on.
</div>


or you could use it like:

=Switch(NZ(Gustav],"") = "", "O after pmt", [CurrencyID] = 1, [Gustav], True, [Gustav] * [ExchangeRage])

I always finish out my SWITCH( ) function calls with a final pair that includes a TRUE and a value to use if none of the other conditions are met.  This guarantees that if none of the original conditions are met, I will still get a value returned that I can filter on.

<div>
<div class="content wysiwyg-content">
Experts, I am trying to make a switch statement out of the below. &nbsp; I get a wrong number of arguments. &nbsp;The IIF statement works fine separately but I need to add the Nz part and I assume that Switch is the solution. &nbsp;<br />
<br />
=Switch(Nz([Gustav]=&quot;&quot;),&quot;0<wbr /> after pmt&quot;,IIf([CurrencyID]=1,[G<wbr />ustav],[Gu<wbr />stav]*[Exc<wbr />hangeRate]<wbr />))<br />
<br />
thank you
</div>
</div>


Experts, I am trying to make a switch statement out of the below.   I get a wrong number of arguments.  The IIF statement works fine separately but I need to add the Nz part and I assume that Switch is the solution.  

=Switch(Nz([Gustav]=""),"0 after pmt",IIf([CurrencyID]=1,[Gustav],[Gustav]*[ExchangeRate]))

thank you

Switch

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.