Ceiling function

  • Thread starter Thread starter Boon
  • Start date Start date
B

Boon

Hello,

Please answer this question for both using in query and using in VBA.

Is there a ceiling functio in Access? e.g Ceiling(5.23) would give a
result of 6

Thanks,
Boon
 
You mean like always rounding up? Try this:

fieldname: round(5.23+0.5,0) in a query

and you can also use this in VBA

hth
 
Back
Top