Round Up

[DavidPuddyFan]

I field within a query that is using the following expression to get m
a number....

Expr1: IIf([Age] Between 0 An
64,([fEmpBenefitSubFormCompanyNew]![LifeThousands]+[fEmpBenefitSubFormCompanyNew]![LifeRemainder])*1000,IIf([Age
Between 65 An
100,([fEmpBenefitSubFormCompanyNew]![LifeThousands]+[fEmpBenefitSubFormCompanyNew]![LifeRemainder])*650))

Let's say for instance I get the number 178,750. If I want to roun
this up to 179,000, How would I do that....thank

 

[DavidPuddyFan]

found my answer here...

http://tinyurl.com/2y5b

 

[Allen Browne]

In Access 2000 or later, you could use:
=1000 * Round([SomeExpression]/1000, 0)

For earlier versions, grab the Round() function in this link:
http://www.mvps.org/access/modules/mdl0054.htm
and use:
=Round([SomeExpression], -3)