Thanks that worked, but I guess append doesn't pick up calculated fields such as (totpay)/ppdays2. I am probably going to have append without calculation and then cycle though the table rewriting new calculations.