<div>
Try this:<br />
<br />
<br />

<pre><code id="code-20-39558772-1">IIf ({your condition goes here}, ABS(TypeID * (TypeID &gt;10)) , ABS (TypeID * (TypeID &lt; 10)))</code></pre>
</div>


Try this:




IIf ({your condition goes here}, ABS(TypeID * (TypeID >10)) , ABS (TypeID * (TypeID < 10)))

<div>
<div class="content wysiwyg-content">
Hi all!<br />
<br />
Query in MS Access 2013.<br />
<br />
I want to return results based on an IIF function along the lines off:<br />
<br />
If (condition is met, &gt;10 , &lt;10) (In my criteria field of the TypeID column)<br />
<br />
Ie, my criteria must return the records where the typeid field has value less then 10 or if false, values that are greater then 10?<br />
<br />
Easier to ask....<br />
<br />
Thanks<br />
Sean
</div>
</div>


Hi all!

Query in MS Access 2013.

I want to return results based on an IIF function along the lines off:

If (condition is met, >10 , <10) (In my criteria field of the TypeID column)

Ie, my criteria must return the records where the typeid field has value less then 10 or if false, values that are greater then 10?

Easier to ask....

Thanks
Sean

IIF Function using &lt; or &gt; in True / False Part

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.

IIF Function using &lt; or &gt; in True / False Part

IIF Function using < or > in True / False Part