<div>
OR this:<br />
<br />
<br />
<br />
Percentage: FormatNumber(([quantity]*[<wbr />makeup])/1<wbr />00 , 0)<br />
<br />
mx
</div>


OR this:



Percentage: FormatNumber(([quantity]*[makeup])/100 , 0)

mx

<div>
Well, you could do it in the formatting of the field, just set the # of decimals to 0<br />
<br />
Or you could use the Round() function:<br />
<br />
Percentage: Round([quantity]*[makeup]/<wbr />100)
</div>


Well, you could do it in the formatting of the field, just set the # of decimals to 0

Or you could use the Round() function:

Percentage: Round([quantity]*[makeup]/100)

<div>
Brilliant! &nbsp;Amazing the time blown on the small things...I appreciate you!
</div>


Brilliant!  Amazing the time blown on the small things...I appreciate you!

<div>
You are welcome.<br />
<br />
I actually like FormatNumber() better, because IF ... you need two dec pts, you can't get that with Round() - in some cases:<br />
<br />
?Round(55/22,2)<br />
&nbsp;2.5 <br />
<br />
?FormatNumber(55/22,2)<br />
2.50<br />
<br />
mx
</div>


You are welcome.

I actually like FormatNumber() better, because IF ... you need two dec pts, you can't get that with Round() - in some cases:

?Round(55/22,2)
 2.5

?FormatNumber(55/22,2)
2.50

mx

<div>
Great tip to add to my plethora of tips, in fact I should create a database for database tips!
</div>


Great tip to add to my plethora of tips, in fact I should create a database for database tips!

<div>
<div class="content wysiwyg-content">
Hi experts! &nbsp;<br />
<br />
Here is the code I'm using for my calculated field:<br />
<br />
Percentage: ([quantity]*[makeup])/100<br />
<br />
The result currently shows two decimal points. &nbsp;I would like this field to round to the nearest whole number, no decimals. &nbsp;Please help!<br />
<br />
Thank you.
</div>
</div>


Hi experts!  

Here is the code I'm using for my calculated field:

Percentage: ([quantity]*[makeup])/100

The result currently shows two decimal points.  I would like this field to round to the nearest whole number, no decimals.  Please help!

Thank you.

Rounding A Calculated Field in an Access Query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.