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.

Check the Round() (http://www.techonthenet.com/access/functions/numeric/round.php) function.

Here's another example (http://www.vbaexpress.com/kb/getarticle.php?kb_id=424).