The problem seems to be with the FOR condition.

You could handle this by appending into table 1 and then once you have it as a dbf filter out the records you dont want (by either appending into another table or selecting out what you want).

Certainly not the perfect solution, but quite straight forward and quick.