Access Access table append field

Joined
Aug 15, 2015
Messages
1
Reaction score
0
Ok, my problem is...i have a table with 2 field diferent name

Example
ID 1
unit_price 238.56
unit_pricelast ......

It is possible to update "unit_pricelast" with value of "unit_price" but using same ID?

Result:
ID 1
unit_price 238.56 (later i must change value of this field cuz i have items with last month price and price with actual)
unit_pricelast 238.56

ty for fast respond
Goran
 
Back
Top