Roundup value with Int function

  • Thread starter Thread starter mohsin via AccessMonster.com
  • Start date Start date
M

mohsin via AccessMonster.com

Hi there

My function for roundup the value is = Int(-[fieldname]), the result was as
expected, but with - (for example -70), if i don't put -, i got the 69.8.

Can anybody help me please, so as i got 70..:)

thanks
 
Hi

int will give you the integer portion so int(69.8) = 69

If you want it to round then use cint... cint(69.8) = 70

(NB: If you use int on negative numbers, think of it as taking the highest
whole number less than the argument, so int(-69.8) = -70)

Regards

Andy Hull
 
Back
Top