troubleshooting Question

Format calculated field in unbound form to 2 decimal places

Avatar of sannunzi
sannunzi asked on
Microsoft Access
2 Comments1 Solution303 ViewsLast Modified:
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]
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros