Recent content by senthil4hcl

Solved the problem Actually i need excute a ceiling function in access query I used this small calculation in select statement Eg: select (-Int(-441 / 5) * 5) = 445 or select 423-(423 mod 5)+5 =425

Hi All I m using access query where i need something similar to excel ceiling function For an eg., In excel if the value is 213 then ceiling(213,5) =215 216 ceiling(216,5)=220 So i want to round off the value in field to 5 select...