Always Round Up (Never Down)

[Derrick T. Davidson]

I think the answer is no but if I have a number 9.1 or 9.99 is it possible using the round function to always show 10.00?

[alansidman]

You could try this: Int(yourFieldNameHoldingValue)+1

[Derrick T. Davidson]

Perfect thank you sir

[June7]

Is 0 valid data in your table? Would you want it to round up to 1?

Would you want 1.0 to round to 2?

Consider:

x = your fieldname

Int(x) + IIf(x - Int(x) > 0, 1, 0)