I am displaying a percentage on a report. However, the outcome shows up as 33.333337 etc. How do I round off the result to just show 33! I have tried formatting the cell properties to 0 decimal places from within the query and report but it is still showing up the same. Help, again!<br><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Rounding decimal places off
- Thread starter lamaar
- Start date
Leave the query alone...<br>In the report did you try to Format the result in the Control source.<br>Shut off all other properties that you changed so they are the default.<br>Put this in the control source:<br>=Format(YourPercent,"###."
<br><br>also the "Int" function (Convert to an Integer) will truncate any decimals but it won't round up or down.<br><br>=Int(YourPercent)<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
<br><br>also the "Int" function (Convert to an Integer) will truncate any decimals but it won't round up or down.<br><br>=Int(YourPercent)<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.- Thread starter
- #3
- Status
Similar threads
- Locked
- Question