I have an Access 2000 db and am writing a SQL statement using the ABS function. Adding a column of numbers in which there is one negative number "-230". I am using the ABS function to have the negative added as a positive.
What is happening is that the 230 is being added twice so that the result is 230 larger than it should be.
SUM(ABS(WAMT)) AS TOTALEARN
wHY IS IT ADDING THE 230 TWICE?
Tom
faxpay
What is happening is that the 230 is being added twice so that the result is 230 larger than it should be.
SUM(ABS(WAMT)) AS TOTALEARN
wHY IS IT ADDING THE 230 TWICE?
Tom
faxpay