Query with Is Null returning Not Null Records (1 Viewer)

[mr_fish]

Hello all,

A bit of a weird one, I've got a query and the criteria for showing records is that one particular field is null. However the query is showing records with the values in the field chosen for the Is Null.

Not sure why this is happening, has anyone come across this problem before?

Thanks.

 

[KenHigg]

Sounds like it is working perfectly...

The the criteria is 'is null' and the results are 'is null'....

 

[ColinEssex]

If you are saying that there are values in the field that has the IsNull criteria, make sure that if you have 2 or 3 lines of criteria that the IsNull in in all the criteria lines.

Col

 

[mr_fish]

Thanks Col, you saw through my confusing question and adding multiple Is Null criteria has worked in ridding the query of the Not Null entries.

Is that a bug? Oh how can it be, Microsoft..........bug those words can't possibly go together

 

[ColinEssex]

Its not a bug.

The query processes each line and the first line works ok. But as the IsNull is not in other criteria lines, it doesn't include it.

Col