>>>m.nNumber = No >>>m.cPeriod = LEFT(DTOS(DATE()),6) >>>replace still with 1 in 'tab2' for (amount <= 0 OR STR(year1,4)+TRANSFORM(month1,"@L 99")<= m.cPeriod) AND m.nNumber == m.no >>>