Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access Report - Sum a Time Field in an Access Report
I set the [Total Hours To-Date] field as a fixed number with 2 decimal places- terpdavid
- Post #9
- Forum: Microsoft: Access Reports
-
Access Report - Sum a Time Field in an Access Report
I tried the =sum(finish time) - (start time) ... It still returns the whole number. I'm not sure what I've got wrong at this point- terpdavid
- Post #6
- Forum: Microsoft: Access Reports
-
Access Report - Sum a Time Field in an Access Report
AHHHH! Got it! thanks dhookom for the clear direction.- terpdavid
- Post #5
- Forum: Microsoft: Access Reports
-
Access Report - Sum a Time Field in an Access Report
Thanks dhookom, I had read some of your posts and was hoping you'd respond to this one. I'm obviously a novice using this, and need a little more clarification. The field i'm trying to SUM is already in hours:minutes format. I'm not subtracting "days," but hours (start Time - Finish time)...- terpdavid
- Post #3
- Forum: Microsoft: Access Reports
-
Access Report - Sum a Time Field in an Access Report
I have a [Start time] and [Finish Time] field in my access 2007 db. I've also got a [Total Hours] field for each record that calculates just fine as: =Format([Start Time]-1-[Finish Time],"Short Time") ... i got this off of this forum (great job). My problem is in trying to get the sum of...- terpdavid
- Thread
- Replies: 9
- Forum: Microsoft: Access Reports
