 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2008Always round up in calculation
I've reviewed the questions for rounding up but I'm not finding what I need to help me to round in a calculation. My calculation is this =Sum(Abs([RoomType]="Double"))/2 I always want the result to round up with no decimal place. Any help you can give me is greatly appreciated. Thank you > I've reviewed the questions for rounding up but I'm not finding what I need > to help me to round in a calculation. My calculation is this [quoted text clipped - 3 lines] > I always want the result to round up with no decimal place. Any help you > can give me is greatly appreciated. Thank you =-Int(-(Sum(Abs([RoomType]="Double"))/2)) (there's a minus before Int and before the 2nd bracket) Evi I may be missing something, but will this do =iif(NumberToBeRounded=Int(NumberToBeRounded),NumberToBeRounded,int(NumberToBeRounded+1))  SignatureRob Ward > I've reviewed the questions for rounding up but I'm not finding what I need > to help me to round in a calculation. My calculation is this [quoted text clipped - 3 lines] > I always want the result to round up with no decimal place. Any help you > can give me is greatly appreciated. Thank you |
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.