rounding numbers

[lalu mathhew]

Hello,

In MS access 2000 table I have one field called [WAGES]. I gave this field to - Currency Data type. I want to see [WAGES] field’s 5% in Select Query. For e.g. Wages = 1250, I want to see 5% of this [WAGES] field’s. I got the result Rs. 62.50 in Selection Query. I want to round this figures to Rs. 63 i.e. if point is > =.50 I want to round it with next figure. For this purpose, what should I do in Selection Query to get this amount in Access-2000?


Lalu Mathew
(e-mail address removed)

 

[Michel Walsh]

Hi,


Int( 0.5 + ComputedExpression )

would be a working solution for most situations ( and I assume the computed
expression is >= 0 ).


Hoping it may help,
Vanderghast, Access MVP

Hello,

In MS access 2000 table I have one field called [WAGES]. I gave this

field to - Currency Data type. I want to see [WAGES] field's 5% in Select
Query. For e.g. Wages = 1250, I want to see 5% of this [WAGES] field's. I
got the result Rs. 62.50 in Selection Query. I want to round this figures to
Rs. 63 i.e. if point is > =.50 I want to round it with next figure. For
this purpose, what should I do in Selection Query to get this amount in
Access-2000?