how to round up a value to next digit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

if the answer is 5.222 then I want it to be shown as 5
if it is 6.32 then it should be 7
 
In all rounding systems I am aware of, 6.32 would be rounded down to 6. What
basis are you wanting to use to detect whether or not a number should round
up? Do you want all displayed numbers to be odd numbers? If that's the case
then you would have to use something like this in a query:

Iif (Int(YourNumber) Mod 2 = 0, Int(YourNumber) + 1, Int(YourNumber))

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Queries to reduce a set of data pairs 3
round up to the next 1/2 kg....formatting 2
Help with a formula 2
Rounding 2
News CES 2019 round up 6
Rounding Values 2
Rounding up! 2
Round Up a Decimal 6

Back
Top