Q:

Double a value in a column on every row

I need to double the price of all items in a table of a database in access.  Here is what the table structure looks like:
sandwich $5.12
apple    $1.25
I need it to become:
sandwich $10.24
apple    $2.50
How can I accomplish this? 

A:

Use an UPDATE statement to set the price = 2 * price.