Ceiling Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003. I need a field in my report to round up to the next
whole number. For example, I am having one field multiply another field and
the result is $18.20 and it would round up to $19.00.

Any help is appreciated.
 
Scott said:
I am using Access 2003. I need a field in my report to round up to the next
whole number. For example, I am having one field multiply another field and
the result is $18.20 and it would round up to $19.00.
Click to expand...


Here's an expression you can use in a report text box:

=IIf(X = Fix(X), X, Fix(X+1))
 
Back
Top