-
Round up?
I am trying to roundup a calculation using the expression builder but can't find a command to handle this.
Fairly novice user using Expression Builder as opposed to SQL. Any help would be appreciated.
Have tried MROUND, and ROUND which are not recognized
-
-
Need to round up
Corruptor,
Thanks for reply. Looks like INT() rounds down, I need to round up.
Any other ideas?
Thanks again
-
Since I don't know Access deeply I would say no, but...
It takes some time to solve it but it should work:
Create your own function something like this in Basic module:
Function RoundUp(ToRound as Single) as Integer
RoundUp=ToRound
end Function
This will work for sure, 'cause VBA will do the correct rounding for you.
Once you have defined this function you can use it anywhere you want.
Hope this helps.
-
SELECT ROUND(12.55,1);
result 12.6
SELECT ROUND(12.55,0);
result 13
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|