SQL Help

[DuncB7]

Firstly, I'm a novice at this so go easy please. I work in engineering, not under the umbrella of 'IT' - I don't speak the lingo.

I use Microsoft Query via Excel but I'm struggling with 1, 0 and Null lines. What is the most efficient way to display only lines with Null and 0 values?

When I add criteria for <>1, it displays 0 lines but also removes Null values. Equally same result with 'is one of', 'is not one of', 'is less than', etc.

Help, pls.

[DuncB7]

Hero. Saviour of my day.

Tks.

[paulrockliffe]

Your problem is that Null is not treated as a number, because it isn't and the condition you used is one that ignore none numeric values.