How to show a negative number on the table
What kind on number is the field?
--
KARL DEWEY
Build a little - Test a little
"AccessDB" wrote:
I have a clolumn that I want to show a negative number, but Access
shows 0.00%.
Here is the equation that I'm working from.
Unit Price Change = (Proposed Price - Current Price)/Current Price
So Example would be:
Unit Price Change = (378.62 - 382.44)/382.44
This should give us a -1%, But Access is showing 0.00%
May I please get some help on this matter. Thank you.
|