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?
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?