Access SQL SELECT * FROM X WHERE [Field] = null statement

[Sam]

Access quickie question-

Have a table called ValidAxes. Design as follows-
FieldName Type Null OK ?
--------------------------------
ProcessType Text NO
EEType Text YES
....
....
--------------------------------

Have 2 records in the table. Records as follows-
ProcessType EEType ... ...
----------------------------------------
DrillingProcess Delta
DrillingProcess
----------------------------------------

Can fetch the first record using
"SELECT * FROM ValidAxes WHERE [ProcessType] = 'DrillingProcesses' AND
[EEType] = 'Delta'"

How do I fetch record 2 ? There is guaranteed to be only one such
record having EEtype = null. This does not work
"SELECT * FROM ValidAxes WHERE [ProcessType] = 'DrillingProcesses' AND
[EEType] = (null)".

 

[Q. John Chen]

WHERE EEType IS NULL

 

[Sam]

Thanks, that worked !