<div>
Michael74<br />
<br />
Thank you Michael as soon as I looked at your solution it came back to me.Yep it works.<br />
<br />
Alan
</div>


Michael74

Thank you Michael as soon as I looked at your solution it came back to me.Yep it works.

Alan

<div>
<div class="content wysiwyg-content">
Hi EE<br />
In the Access query generator I am trying IIF statment but having a mental block with the use of Not Isnull.<br />
<br />
Com:iif(Not Isnull([Comments],[Comment<wbr />s],&quot;No Comments&quot;))<br />
<br />
I have tried various combinations Is Not Null. IsNull etc. So simple but can't get it right. The error occurs with the Not null section<br />
<br />
chestera
</div>
</div>


Hi EE
In the Access query generator I am trying IIF statment but having a mental block with the use of Not Isnull.

Com:iif(Not Isnull([Comments],[Comments],"No Comments"))

I have tried various combinations Is Not Null. IsNull etc. So simple but can't get it right. The error occurs with the Not null section

chestera

Access query generator

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.