Getting Negative Number

[Guest]

I'm using an iIf event to solve what percentage larger or smaller a 2nd
number is that the 1st number.

=IIf([TextOrg]>[TextCom],([TextCom]-[TextOrg])/[TextOrg]*100,([TextOrg]-[TextCom])/[TextOrg]*100)

Then another box just gives me Larger or Smaller Text, depending on which is.

It works just fine until I get to larger numbers. If Org is 326,122 and Com
is 666,523, I get 104 "percent Larger".

But, when Com is changed to 1,264,257, instead of 288 "percent Larger" I get
-288 "percent Smaller".

BTW-the "percent Larger/smaller" are handled in a separate text box that
just compares Org to Com.

 

[Graham R Seach]

Wrap your calculation in the Abs() function:
Abs(-1) = 1
Abs(1) = 1

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html