 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2005Round up without using visual basic (equivalent to Roundup())
I need to round up a value in a query to a multiple of 2: Example: 3.14 would round up to 4, 4.001 would round up to 6. How do I do this using the round function? I'd suggest you divide by 2, use the round to get the next whole number and double the answer. >I need to round up a value in a query to a multiple of 2: Example: 3.14 >would > round up to 4, 4.001 would round up to 6. How do I do this using the round > function? > I need to round up a value in a query to a multiple of 2: Example: > 3.14 would round up to 4, 4.001 would round up to 6. How do I do this > using the round function? Is not clear for the criteria for roundish Or better, J understand 3 to 4 but not 4 to 6  Signature_ _ Ciao MAssimiliano Amendola Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5 Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it >>I need to round up a value in a query to a multiple of 2: Example: >>3.14 would round up to 4, 4.001 would round up to 6. How do I do this >>using the round function? > > Is not clear for the criteria for roundish > Or better, J understand 3 to 4 but not 4 to 6 2, 4, 6, 8 who do we appreciate.... SignatureMGFoster:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA) >>> I need to round up a value in a query to a multiple of 2: Example: >>> 3.14 would round up to 4, 4.001 would round up to 6. How do I do [quoted text clipped - 4 lines] > > 2, 4, 6, 8 who do we appreciate.... Interval of two units? ohhh So If Int(Yournum) < Yournum then YouNum = Int(YourNum)+2 Signature_ _ Ciao MAssimiliano Amendola Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5 Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.