Making all values negative

[Brendan Mather]

I have a column in a table and I'd like to make all 7100 values to be
negative, what's the fastest way to do this.

thanks,
Brendan

 

[Rick Brandt]

I have a column in a table and I'd like to make all 7100 values to be
negative, what's the fastest way to do this.

Update query.

UPDATE YourTableName
SET YourField = Abs(YourField) * -1

 

[Brendan Mather]

thanks very much

Update query.

UPDATE YourTableName
SET YourField = Abs(YourField) * -1