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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
..
 
shubham said:
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
Click to expand...
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.
 
Back
Top