Roundup

[SRN]

Hi,

Can someone please help, i need to round up figures, it works fine in Excel but i need to now use access, anyway i need to convert 0.185 to 1 and so on. Can't seem to find the correct way to do it.

Please can someone help

Thanks

 

[Rich]

Change the field to an Integer

 

[SRN]

I have already tried this buy using CInt([number]) and it converts 0.185 to 0 Am i doing something wrong?

 

[Rich]

Have you tried Int([YourNumb])?

 

[SRN]

Hi Rich,

yes just tried int([number]) still returning 0.185 as 0

any other ideas??

 

[R6Flyer]

int([number]+0.5)