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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top