does Access have a Roundup function?

[Kevin]

Hi

in MS Excel there is a worksheet function to roundup values say from 12.32
to 13 ie =roundup(A1,2)

Is it possible to do something similar in the design query of Access

 

[Allen Browne]

Negate. Take the integer value. Negate:

= - Int( - [MyField])

 

[Kevin]

nice - thanks
--
Kevin

Negate. Take the integer value. Negate:

= - Int( - [MyField])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi

in MS Excel there is a worksheet function to roundup values say from 12.32
to 13 ie =roundup(A1,2)

Is it possible to do something similar in the design query of Access