Change values to negatives

[Iram]

Hello.
I would like to create an update query that will change the values to
negative numbers. The values are in currency format. For Example I have
records with $5.00 but I would like to run an update query that will change
the $5.00 to a negative number (5.00).
How would I create the query?

Your help is greatly appreciated.

Iram/mcp

 

[NuBie]

update
Amount
Set Amount = Amount * -1;

 

[NuBie]

update
<Table>
Set <Table>.<Field> = <Table>.<Field> * -1;

i.e.

Update
BillTable
Set BillTable.Amount = BillTable.Amount * -1;

update
Amount
Set Amount = Amount * -1;

Hello.
I would like to create an update query that will change the values to

[quoted text clipped - 6 lines]

Iram/mcp