move data from one column to another in table

[DAPPLE]

I have a form set up through a table. On this table I had information in the wrong column. I put the bonus percent instead of bonus amount in amount column. I would like to get that copied and pasted to the percent column so it will correctly reflect on the form. Does any one know how I can do that? Please and thank you.

 

[Jack Cowley]

You can use an Update Query to add the data to the correct column then another Update query to delete the first column.

 

[Pat Hartman]

Since you don't need both columns in the table (BonusAmt is calculated by multiplying BonusPct and some other field), delete the empty BonusPct field and rename the BonusAmt to BonusPct.