I want to round up a sum value. 1.50 and above to 2, 1.49 and below to 1. How can i achieve this. I have tried to apply the round function but failed since i know very very little about this access.
Actually i want the rounded figure (1.50 and above to 2, 1.49 and below to 1) to appear in one of my reports, and i think this (I mean changing the way the value is stored in the table) is the only way to achieve that.
If i have to make/build an expression for this, please let me know in detail, how to do that, because i have tried to do that before but failed.
Actually i want the rounded figure (1.50 and above to 2, 1.49 and below to 1) to appear in one of my reports, and i think this (I mean changing the way the value is stored in the table) is the only way to achieve that.
If i have to make/build an expression for this, please let me know in detail, how to do that, because i have tried to do that before but failed.