How to show a negative number on the table

[AccessDB]

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.

 

[John W. Vinson]

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.

Take a look at the two good answers posted half an hour before you reposted
your original question.

My guess is that the Unit Price Change field is the default Number datatype, a
Long Integer; integers are by definition whole numbers.

John W. Vinson [MVP]