Update MWTRN
Set
 [Insurance 1 Paid] = True,
 [Insurance 2 Paid] = True,
 [Insurance 3 Paid] = True,
 [Guarantor Paid] = True,
 [Attorney Paid] = True
Where
[Transaction Type] >= 'A'
and [Transaction Type] <= 'H'
and Round(Amount + [Insurance 1 Amount Paid] + [Insurance 2 Amount Paid] + [Insurance 3 Amount Paid] + [Guarantor Amount Paid] + [Attorney Amount Paid] + [Adjustment Amount], 2) = 0