Rounding on a report

[William Carl]

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]

Try something along these lines:

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

Simon.