Ceiling function

[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

 

[Maurice]

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

 

[Boon]

Yes,

I mean rouding up. Your trick is very cool.

thanks