 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / February 2006calculating time (HH:MM) totals within access 2002 reports
I have created a access database whose table consists of records with a overtime data field containing hours and minutes (HH:MM). I would like to create a total field at the end of the report that will give me the total over time for all records. How can I do that within the report? Is it easier to use just one field like I have above or use two fields suchs as HH and MM then perform the calculations? What is the field name and data type? HH:MM is not a field type. It might be a format but could be a text field. A word of caution... it is rarely a good idea to store a duration of time in a date/time field. Durations should be stored in numeric field with values describing the number of hours or number of minutes. Picture storing six days as 1/5/1900. These are actually the same value. Six hours should be stored as 6.0 hrs and not 6:00 AM. 6 and 3/4 hours should be stored as 6.75 hours or 405 minutes.  SignatureDuane Hookom MS Access MVP -- >I have created a access database whose table consists of records with a > overtime data field containing hours and minutes (HH:MM). I would like to [quoted text clipped - 4 lines] > like I have above or use two fields suchs as HH and MM then perform the > calculations? It is not stored in a numeric field as you recommended. I can change that. But once that is done, how do I total up the hours and minutes? specifically, how do I convert all the minutes in the minutes field to hours? > What is the field name and data type? HH:MM is not a field type. It might be > a format but could be a text field. [quoted text clipped - 15 lines] > > like I have above or use two fields suchs as HH and MM then perform the > > calculations? To get from minutes to hours, divide by 60. 90 minutes = 1.5 hours. SignatureDuane Hookom MS Access MVP -- > It is not stored in a numeric field as you recommended. I can change > that. [quoted text clipped - 29 lines] >> > like I have above or use two fields suchs as HH and MM then perform the >> > calculations? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.