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]