Number field in query

[foxy]

Hi everyone.

I have a number field in my table that contains numbers 1, 2, 3, 4, and also blanks.

I am writing a query from the table as I dont want to see the rows that have a value of '1' in that field.

When I write the following selection criteria...

WHERE [table].[field] <> 1

The query then also omits the blank rows from the table...

Can someone tell me why it is doing this?


Cheers

Foxy

 

[namliam]

A null is a Null, not anything else and not not anything else
Something = Null
Something <> Null
Both return False, if you want to include nulls you have to "correct" or account for it to be there:
Account for it: Field <> 1 or Field is null
or Correct it: NZ(Field, -1) <> 1

I hope its clear enugh of an explanation.

Good hunting