Link to home
Create AccountLog in
Avatar of sannunzi
sannunzi

asked on

Format calculated field in unbound form to 2 decimal places

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]
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of sannunzi
sannunzi

ASKER

Thank you, worked like a champ!!!