var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access SQL Rounding
I have a simple and hopefully quick question.
How do Access to ROUND a number up for any decimal.
8.1 = 9
8.2 = 9
8.5 = 9
8.9 = 9
If I do a Round, it only rounds if its .5. Is there any way to specifiy to round up at ANY decimal?
Well, I did some more searching and came up with a solution (refer to: http://groups.google.ca/groups?hl=en...3DN%26tab%3Dwg)
I didn't know that you could reference your own custom functions in sql queries.
I think that could have been done a little cleaner...
Personal preference only of course...
If Round(i, 0) < i Then
result = Round(i, 0) + 1
result = Round(i, 0)
that is cleaner. thx for the reply.