<div>
In the table field settings (design view)?<br />
<br />
Wendee
</div>


<div>
to update existing field, something like this:<br />
<br />
update table set col=round(col,4)<br />
<br />
you can use round(col, n) in your select statements as well...
</div>


<div>
pwdells,<br />
<br />
Yes, that's right.<br />
<br />
Please back up your data before attempting such a change, though :)<br />
<br />
Patrick
</div>


<div>
&gt; .. a remaining variable with an amount ..<br />
<br />
If you are handling amounts you should at once change any use of Double to Currency any place in your code and tables. If not, you will be bitten by the behaviour with tiny calculation errors - often when you least expect it.<br />
<br />
/gustav
</div>


<div>
What I did was change the field types to decimal with Scale and Decimal Field attributes set to 3. &nbsp;It is not a current field, it is bulk material weights.
</div>


<div>
Make sure you set the Decimal Places and Scale attributes to the number of places to the right, to ensure you don't lose data within your field.
</div>


<div>
<div class="content wysiwyg-content">
Quite often, after allocating stock into orders, I get a remaining variable with an amount like this: 9.74100000000001 &nbsp;<br />
<br />
How can I just trim the variable to just 9.741 and have it stored in the database field like that?<br />
<br />
Thank you in advance!<br />
<br />
Wendee
</div>
</div>


Quite often, after allocating stock into orders, I get a remaining variable with an amount like this: 9.74100000000001  

How can I just trim the variable to just 9.741 and have it stored in the database field like that?

Thank you in advance!

Wendee

Trimming a double variable in VBA / SQL.

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.