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!