what is the equivalent of ceiling function of excel in access?

[shubham]

i want to round up the value of the calculated field to nearest multiples of
50. In excel we can do this by ceiling function. what do we do in access?

 

[John Spencer]

IF your numbers are positive you can try the following. I've not tested it
extensively.

-Int(-[TheField]/50) * 50

The value returned is always rounded toward postive infinity. So negatrive
49 will return zero

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Chris2]

i want to round up the value of the calculated field to nearest multiples of
50. In excel we can do this by ceiling function. what do we do in

access?

shubham,

You can try setting a reference to the MS Excel Object Library.
(Tools>Macros>Visual Basic Editor>Tools>References)

MS Access may allow you to use some MS Excel functions if you do this.
(Some work, some don't.)


Sincerely,

Chris O.