View Single Post
  #1  
Old April 24th, 2007, 05:49 PM posted to microsoft.public.access.tablesdbdesign
AccessDB
external usenet poster
 
Posts: 23
Default How to show a negative number on the table

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.