very newbie question

[Tonatiuh]

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!

[DrewDog_21]

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