<div>
Thanks for the help and the quick reply
</div>


<div>
Just in case anyone should happen to look up this post:<br />
<br />
That is really the most clumsy rounding &quot;method&quot;, I've ever seen. And it fails in an international environment.<br />
Numbers should always be handled like numbers. <br />
<br />
Here is how to do this:<br />
<br />
dblNumber = 131.2999999998<br />
lngNumber = Int(dblNumber * 1000) / 1000<br />
<br />
Returns 131.299<br />
<br />
/gustav
</div>


Just in case anyone should happen to look up this post:

That is really the most clumsy rounding "method", I've ever seen. And it fails in an international environment.
Numbers should always be handled like numbers.

Here is how to do this:

dblNumber = 131.2999999998
lngNumber = Int(dblNumber * 1000) / 1000

Returns 131.299

/gustav

<div>
<div class="content wysiwyg-content">
In MS Access vba code I want to return an unrounded version of a number trunctated to a specified number of decimal places.<br />
<br />
For example, I &nbsp;have a number of &nbsp; 131.2999999998<br />
<br />
I want to truncate this number to 3 decimal places and end up with 131.299, &nbsp;NOT 131.3<br />
How do I do that?
</div>
</div>


In MS Access vba code I want to return an unrounded version of a number trunctated to a specified number of decimal places.

For example, I  have a number of   131.2999999998

I want to truncate this number to 3 decimal places and end up with 131.299,  NOT 131.3
How do I do that?

How to return unrounded number

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.