<div>
Thank you, worked like a champ!!!
</div>


<div>
<div class="content wysiwyg-content">
I have an access form with a calculated field that comes up with several decimal places. &nbsp;The table I am writing it to in Sql server is 2 decimal places. &nbsp;How do I format the field before I write it so that it will go into sql server. &nbsp;<br />
The field name is Difference_1 and <br />
this is the calculation &nbsp; =[Hours_Req_to_Drill_1]-[H<wbr />ours_on_DT<wbr />_Log_1]
</div>
</div>


I have an access form with a calculated field that comes up with several decimal places.  The table I am writing it to in Sql server is 2 decimal places.  How do I format the field before I write it so that it will go into sql server.  
The field name is Difference_1 and 
this is the calculation   =[Hours_Req_to_Drill_1]-[Hours_on_DT_Log_1]

Format calculated field in unbound form to 2 decimal places

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.