Querying data type issue

[grenee]

Good evening all,

My table field is data type NUMBER. It contains values 1,2,3,4 and some blank values. I want my query to return all records excluding those with the 3 and 4 values.

This is my query entry: <3

This returns records with 1 and 2 only but excludes the blanks which I want included.

I tried using IsNull to return the blank records but I get an message say Mismatched type

Is this a great challenge

 

[spikepl]

1. The sun never sets on AWF so Good morning/evening makes little sense
2. When you say I tried bla blah do not give an ambiguous narrative but supply an unambiguous code example
3. Criterion for including all, in the Criteria-cell of the query design grid:

<3 Or Is Null

(note 2 words: Is Null -there also is a VBA function IsNull()), but in SQL one should use SQL facilities)

 

[JHB]

Have you tried the below as criteria?

WHERE YourNumberfieldName<3 OR YourNumberfieldName Is Null;

 

[grenee]

Thanks. You must be some sort of expert. This was solved in 1 shot.