By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,390 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,390 IT Pros & Developers. It's quick & easy.

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

P: n/a
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)".

Nov 17 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
WHERE EEType IS NULL

Nov 17 '05 #2

P: n/a
Sam
Thanks, that worked !

Nov 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.