I have a column that is frequently updated with an append query. I need to turn all of the incoming positive values into negative values (as well as convert all of the existing). I tried to multiply the column by -1 in the formula option in table design view but couldn't find the proper formula format.
Can anyone suggest an approach.I'd use something like:UPDATE myTable
SET bogusColumn = - Abs(bogusColumn)-PatP
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment