View Full Version : Rounding on a report


William Carl
03-20-2002, 11:28 AM
I have a total on a report which shows the percent of inspections correct based on the following expression in the Control Source for the text box
=[txtnocorr]/[txtnoofinsp].
My format is percent and my decimal places are zero
My problem is that when dividing 902(txtnocorr) by 904(txtnoofinsp) the % displayed is 100 instead of 99. I don't know how to get the results as integer.

Can someone out there help me?
Thanks --- Bill

SimonC
03-21-2002, 03:07 AM
Try something along these lines:

Format(CInt(Left([txtnocorr] * 100 /[txtnoofinsp],3)),"##0") & "%"

Simon.