Ceiling Function

S

Scott

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.
 
M

Marshall Barton

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))
 
Top