Filtering out numbers

[GarryWelborn]

Hi,

I've set up a query and are trying to set the criteria in one of the fields to exclude any entries where the number 40 appears. In the criteria I have entered <>40, but when I run the query it is also
excluding the blank cells which I want to retain. Can anyone offer some advice please?

Regards

Garry

 

[james_lankford]

select 
  *
from
  tbl
where 
(
  num <> 40 
  or 
  num is null
)

 

[GarryWelborn]

Thank you James, that has worked