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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing negative number to a positive number 16
Negative Numbers in a Pivot Table 1
Conditional Negative Number 1
Using abs in reports 1
Calculating % based on negative divisor 1
Sum not recoginzing a negative number 5
Currency Alignment 2
Subtracting positive amts from negative and positive from positive 3

Back
Top