<div>
use the NZ() function instead of IsNull in queries<br />
<br />
it works better for me...
</div>


use the NZ() function instead of IsNull in queries

it works better for me...

<div>
dox_fsa: IIf(IsNull([7]),IIf(IsNull<wbr />[19],False<wbr />, IIf([19]&gt;0,True,False)),II<wbr />f([7]&gt;0,Tr<wbr />ue,IIf(isN<wbr />ull([19]),<wbr />False,IIf(<wbr />[19]&gt;0,Tru<wbr />e,False)))<wbr /><br />
<br />
&nbsp; Think I got enough parends on the end.<br />
<br />
JimD
</div>


dox_fsa: IIf(IsNull([7]),IIf(IsNull[19],False, IIf([19]>0,True,False)),IIf([7]>0,True,IIf(isNull([19]),False,IIf([19]>0,True,False)))

  Think I got enough parends on the end.

JimD

<div>
<div class="content wysiwyg-content">
Hey,<br />
<br />
Can someone help me with the formatting of a line of my query. I am trying to say;<br />
if column[7] is null then check column [19], if they are both null return FALSE. <br />
if column[7] is not null check its value is greater than 0, if it is not greater than 0, check column [19] value is greater than 0, if it is also not greater than 0 return FALSE, but if either column [7] or [19] return a value greater than 0 return TRUE. <br />
<br />
I have tried to do this in a query, and I need to keep it in this format.<br />
<br />
dox_fsa: IIf(IsNull([7]),IIf(IsNull<wbr />[19],False<wbr />,IIf([7]&gt;0<wbr />,True,IIF[<wbr />19]&gt;0,True<wbr />,False))<br />
<br />
Something like that?<br />
<br />

</div>
</div>


Hey,

Can someone help me with the formatting of a line of my query. I am trying to say;
if column[7] is null then check column [19], if they are both null return FALSE. 
if column[7] is not null check its value is greater than 0, if it is not greater than 0, check column [19] value is greater than 0, if it is also not greater than 0 return FALSE, but if either column [7] or [19] return a value greater than 0 return TRUE. 

I have tried to do this in a query, and I need to keep it in this format.

dox_fsa: IIf(IsNull([7]),IIf(IsNull[19],False,IIf([7]>0,True,IIF[19]>0,True,False))

Something like that?



IIf Statments in queries

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.