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

For that, you can:

select field1, field2, (totPay)/ppdays2 as calcField ...

This gives the calculated field a name that you can append into the new cursor.