Access Formula Gone Wrong!
Posted on 2011-03-08
We have a Query that is used to calculate the employees profit:
Now this query work fine most of the time except when there is a return and so we could get numbers like this:
The Number should be -$192 instead it calculates out as -$1001.9
Can anyone elaborate a better way to present this formula so it works correctly?