Rounding to Hundredths

  • Thread starter Thread starter Tina Hudson
  • Start date Start date
T

Tina Hudson

I want to write a calculated expression that will add a
number to an existing numerical field, and then round the
sum to the nearest 100th.

Example: A school has a capacity of 870. I add 100 (to
determine the capacity for the media center and dining
area) for a total of 970. However, I want my calculated
expression to be computed as 1,000.

Can Access do this, and if so, how?

Thanks!
Tina Hudson
 
Tina;

From Access Help:
ROUNDUP
Rounds a number up, away from 0 (zero).

If this function returns the #NAME? error value, you may need to install
msowcf.dll.

Syntax
ROUNDUP(number,num_digits)

Number is any real number that you want rounded up.

Num_digits is the number of digits you want to round to. Negative rounds
to the left of the decimal point; 0 (zero) or omitted rounds to the nearest
integer.

Hope it helps.

Andy
 
Andy:

I didn't get the #Name? error value, I got the #Error
value. Interestingly, I could type in "RoundUP" to write
the calculated expression, but when I clicked F1 on the
word "RoundUP", it wouldn't give me any help on the
subject. I tried to enter the word in the index, but it
only listed "round".

Anyway, I don't have the .dll file installed, but will try
your suggestion, once I do.

Thanks so much for your help! It is most appreciated.

Tina
 
If the above suggestions do not work, you could try:
Int([YourField]/100)*100
You want to play with the numbers to obtain exactly what
you want.
with regard to the #error, make sure your textbox is not
named the same as a field name.
Hope this helps.
Fons
 
Fons:

Worked great! Thanks so much!

Tina

-----Original Message-----
If the above suggestions do not work, you could try:
Int([YourField]/100)*100
You want to play with the numbers to obtain exactly what
you want.
with regard to the #error, make sure your textbox is not
named the same as a field name.
Hope this helps.
Fons
-----Original Message-----
Andy:

I didn't get the #Name? error value, I got the #Error
value. Interestingly, I could type in "RoundUP" to write
the calculated expression, but when I clicked F1 on the
word "RoundUP", it wouldn't give me any help on the
subject. I tried to enter the word in the index, but it
only listed "round".

Anyway, I don't have the .dll file installed, but will try
your suggestion, once I do.

Thanks so much for your help! It is most appreciated.

Tina

may
need to install
.
Click to expand...
.
Click to expand...
 
Back
Top