I need help with significant figures in Access 2000
Posted on 2003-02-24
Hello all you excellent experts! I need help with significant figures in Access 2000.
I have a report where [ReportResults] is a known value in 2 significant number format. I need to take that number and divide it by another number [OrderDetails_User2], not in a 2 significant figure format and different each time - then divide that by 1000. What happens is that in most cases I wind up without a 2 significant figure format. For instance -1.49 / 379.60 / 1000 = 3.9251. I’d like to report only 3.9. This is not a simple decimal point issue. In some cases I may have a value of 0.0000879, I would only report 0.000087, a number such as 4,376 would be 4400 or .00764 would report as .0076, so the placement of the decimal point is not the issue. Then N/A reports when the value for [OrderDetails_User2] is 0. The other bad thing that happens is sometimes [ReportResults] has a less than symbol (<) which renders it useless as a number and therefore it won’t calculate at all. The sorry calculation I use now is:
I am open to all suggestions, I bow to your superior knowledge.