How can I fileter the records where certain field has a null value or another certain value. Something like this:
SELECt * FROM table WHERE field='E' or fild=null
It is an Microsoft Access DB.
Thanks!
Printable View
How can I fileter the records where certain field has a null value or another certain value. Something like this:
SELECt * FROM table WHERE field='E' or fild=null
It is an Microsoft Access DB.
Thanks!
for strings:
"Select * From MyTable Where MyField = 'E'"
for numeric values:
"Select * From MyTable Where MyField = 2"
for dates:
"Select * From MyTable Where MyField = #23/01/2000 12.45.00#
for nulls:
"Select * From MyTable Where Not IsNull(MyField)"
cheers man, hope that helps