>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.

You don't have to do that. In select statement assign names to the calculated filelds using as clause (totpay)/ppdays2 AS Somefiled. If you don't foxpro will name them exp_1, exp_2 and so on.