[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

time calculation on form

Posted on 2011-09-19
3
Medium Priority
?
311 Views
Last Modified: 2012-05-12
i have attached sample db- open and a form comes up-
in is 8:00 am
out is 11:00 am
when you hit calculate button now it displays 3 - for hours between in and out-
If you look at calculate button code- you see i have 30 minutes being subtracted.
( if i have written code correctly)
Is there a way to display the decimal values in monday text button?
right now it displays 3
i want it to display 2.50
thank you
test20.mdb
0
Comment
Question by:davetough
  • 2
3 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36561761
test this
test20Rev.mdb
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 36561869
you have to use Single for the Field size of field Dmonday in the design view of your table
and use this calculation
Me.txtMonday = (DateDiff("n", Me.txtMonIN, Me.txtmMonOUT) - 30) / 60
0
 

Author Closing Comment

by:davetough
ID: 36561980
Thanks for solution and explanation
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month8 days, 2 hours left to enroll

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question