General discussion

Locked

Round Up Deximal Places Nearest to 5 ?

By chailinglee ·
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 conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums