G
Guest
Hello!
My task is to round all up:
2.1=3
2.2=3
....
2.9=3
Is it possible to do in a query?
Thank you!
My task is to round all up:
2.1=3
2.2=3
....
2.9=3
Is it possible to do in a query?
Thank you!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Use the Int function like this
Int([YourNumber] + .99)
Int([YourNumber] + .99)
G
Guest
Try this
Select Round(FieldName + 0.5) As NewRoundUp From TableName
Select Round(FieldName + 0.5) As NewRoundUp From TableName
G
Guest
That works if the Fieldname has a decimal but does not work for whole numbers.
2.1 will round to 3 but 2.0 will also round to 3
2.1 will round to 3 but 2.0 will also round to 3
G
Guest
You right, thank you for that.
--
--
Dennis said:That works if the Fieldname has a decimal but does not work for whole numbers.
2.1 will round to 3 but 2.0 will also round to 3
J
James A. Fortune
Beatrix said:Hello!
My task is to round all up:
2.1=3
2.2=3
...
2.9=3
Is it possible to do in a query?
Thank you!
SELECT Int([X]) + Abs([X] <> Int([X])) AS XRoundedUp FROM MyTable;
James A. Fortune