m.nNumber = No
m.cPeriod = LEFT(DTOS(DATE()),6)
replace still with1in'tab2'for (amount <= 0 OR STR(year1,4)+TRANSFORM(month1,"@L 99")<= m.cPeriod) AND m.nNumber == m.no
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller The only thing normal about database guys is their tables.
