Rounding Down

[skwilliams]

I'm having some real problem with a rounding down function.

I have three fields (Min1, Min2, Min3) which I need to round down to the nearest whole number.

What's the best way to do this.

I've tried the function posted on the Microsoft Support site, but it isn't working. I've copied the code.

I'm getting an error "Function not defined".

Any suggestions are greatly appreciated.

Steve

 

[R. Hicks]

Use the Int() function to round the values down.

HTH
RDH

 

[skwilliams]

Could you show me an example.

I don't think I get it.

My field Hr1 is 8.686. I would like the field to display 8 instead of rounding up to 9.

Thanks.

 

[skwilliams]

I think I've figured it out.

Thanks for all your help.