need negative values

[sueviolet]

I have a field which contains positive numeric values (122)

I need to change all the records in this field so they are negative (-122)



How do I do this?

 

[Rich]

Multiply them by -1

 

[Nouba]

Try an update query

UPDATE theTablename SET [aNumber] = [aNumber] * -1

 

[sueviolet]

Thankyou both - worked fine