If you turn that VBA SQL into a Query what result do you get?

Are you saying that the SQL finds records that do not meet it's conditions?