View Full Version : Query usage with 'is not null' ?


Rich_Lovina
10-15-2001, 06:21 PM
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
10-16-2001, 01:22 PM
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.