need help with rounding in access wrote:
> In need to roundup a simple markup formula for pricing. Does Access permitIn:
> the rounding up to the nearest $10?
Van T. Dinh
You can use:
- Int( - [YourNumber] )
That was a very clever idea. Graphing Int(x), flipping everything
Now, adjust the function so that it rounds up to the nearest 10:
-10 * Int(-X / 10#)
The '/ 10#' scales X up by a factor of 10 since 10 units in the new
-10 * Int(-32 / 10#) = -10 * 4 = 40 (32 -> 40)
Perhaps throw in an NZ() around the field name to guard against Null
James A. Fortune
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.