OK, let me point out that Access doesn't do this quite right by itself. But it can help YOU to do it and maybe I can give you some ideas.
First, you need to consider a change of data format (at least temporarily). You didn't supply names, which is OK because I can make some up. In VBA code, you can compute what you want via DSum.
Code:
Dim TimeSum as Date
Dim AccumTime as String
...
TimeSum = DSum( "CDate([RecLabHrs])", "tblLabHrs", "...selection criteria" )
AccumTime = Format( TimeSum, "hh:nn" )
Note that this WILL NOT WORK if the sum is greater than 24 hours. For that you would need to build a function to do custom formatting. That is because Access does not have a time format that allows you to have something like 124:31:12 - an "elapsed" time format. It has limited date/time format conversions even though the math works out correctly. The math works because internally, Date format is a typecast of Double format and therefore can be used (carefully) for math operations on date. But for reasons I have yet to understand, they omitted one of the most common possible formats - elapsed time.
SELECT SUM(CDate([RecLabHrs])), EmpID FROM tblLabHrs WHERE LaborDate BETWEEN #<put start date here># AND #<put end date here># GROUP BY EmpID;
If you use the Search function on this forum you might find some articles on Date variables and Time Formatting. The SEARCH option is 3rd from the right on the thin ribbon near the top of this page, just under the box that shows your login name to the forum.
