G Guest Mar 7, 2006 #1 How do you calculate the total hours worked per week. At present I am using a "Short Time" format to record the daily hours worked.
How do you calculate the total hours worked per week. At present I am using a "Short Time" format to record the daily hours worked.
J Jeff Boyce Mar 8, 2006 #2 The Access Date/Time data type does NOT record "daily hours worked". It preserves a "point-in-time" value. Because of this, what you believe you have been saving is actually a series of date/times. Save the "hours worked" as a number data type. You can't add date/times, you can add numbers. Regards Jeff Boyce Microsoft Office/Access MVP
The Access Date/Time data type does NOT record "daily hours worked". It preserves a "point-in-time" value. Because of this, what you believe you have been saving is actually a series of date/times. Save the "hours worked" as a number data type. You can't add date/times, you can add numbers. Regards Jeff Boyce Microsoft Office/Access MVP
G Guest Mar 8, 2006 #3 Are you using a start field and a stop field in the daily record? Post your table structure.
