subtracting negative number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to do a calculation in an Access report that takes a positive
number and subtracts a negative number. I keep getting an error. What is
best way to get this to work. It is currency. For example: $121.30 -
($9.57) or [total] - [commission] with total being a positive and commission
being a negative.
 
I am trying to do a calculation in an Access report that takes a positive
number and subtracts a negative number. I keep getting an error. What is
best way to get this to work. It is currency. For example: $121.30 -
($9.57) or [total] - [commission] with total being a positive and commission
being a negative.
Click to expand...

What error?
If [Commission] is stored as a negative value (i.e. -9.57),
then 121.30 - (-9.57) = 130.87 (which is not an error).
If that is the kind of 'error' you are getting, either store the
commission as a positive value and subtract it from [Total] , or else
add it to [Total]. 121.30 + (-9.57) = 111.73.
 
Back
Top