<div>
Using the NZ will slow down the query. it is already performance sensitive so I dont it want to slow down anymore.<br />
<br />
Whats the reason for this behavior ? Why is NULL excluded when I want to exclude another value ? That makes no sense for me ???<br />
<br />
Andy<br />

</div>


Using the NZ will slow down the query. it is already performance sensitive so I dont it want to slow down anymore.

Whats the reason for this behavior ? Why is NULL excluded when I want to exclude another value ? That makes no sense for me ???

Andy


<div>
<div class="content wysiwyg-content">
I use the Filter excluding selection from the standard access contextmenue. If the user selects all excluding a certain value, all NULL-values are deselected as well. I know, that when I use the NZ function in the query, the filter is set properly. But for this all queries of all forms has to be adapted. Is there an easy way to fix this problem ?<br />
<br />
Andy
</div>
</div>


I use the Filter excluding selection from the standard access contextmenue. If the user selects all excluding a certain value, all NULL-values are deselected as well. I know, that when I use the NZ function in the query, the filter is set properly. But for this all queries of all forms has to be adapted. Is there an easy way to fix this problem ?

Andy

Filter excluding selection excludes NULL-values

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.