Query usage with 'is not null' ?

[Rich_Lovina]

Why, when switching on totals if some records are blank and criteria is set “is not null”, a null record is included in the unique set?

 

[llkhoutx]

You may have some other criteria which is allowing the record through.

If so, use the "Is Not Null" criteria on a row by itself.