... tON m.invnum = t.invnumSET m.amount = IFNULL( t.t01, 0 ) This demonstrates the use of this method that can be used in similar circumstances, without writing complex SQL statements. Full Syntax: METHOD UpdateSummary( cMaster, cMasKey, acMasCols, ; ...