multiply all values in one column and update

[weixiang]

hello,

does any1 here noes how to multiply all the values by a number and update it back to the database.

I'm using microsoft access and VB 2005

eg. multiply by 2
Value
--------
2
10
8


result
-------
4
20
16