Ok, this is my query, SELECT * FROM TABLE WHERE (resultcode = "TNS") AND (ondate = #somedate#)This is working fine, however I need to eliminate all results that have a resultcode of "SLE,SLD,SL1, or SL2" between now and the "somedate".Can someone help me with the syntax? Thanks