Round Up Deximal Places Nearest to 5 ? - TechRepublic
General discussion
August 11, 2004 at 07:55 AM
chailinglee

Round Up Deximal Places Nearest to 5 ?

by chailinglee . Updated 21 years, 11 months ago

How to round up deximal places when i do the calculation using the union query. Although i have set the format property, but when it is union query it will not follow what we had set.
Example:0.833333 + 1.33333, union query will sum up as 2.17 when i set the deximal point property to “Fixed” in report.But if we manually calculate, I just want 2 deximal places, i.e 0.83 + 1.33 = 2.16. So how?

This discussion is locked

All Comments