Thread: How to show a negative number on the table
View Single Post
  #3  
Old April 24th, 2007, 06:48 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
  
Posts: 10,767
Default 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.