Use Excel

You can't refer another column within Access table. Export the table to Excel and do it there, then import the modified table. If some of the data contain decimal you need to convert it to text and then convert it back to decimal, otherwise you'd see some funny numbers.