I was a little too quick in thinking I had it. My Original goal was to aggreaget all time pairs between two dates. My earlier post was successful in doing that for a single date, but when I tried modifying it to include a From and To date parameter, I'm getting stuck on returning a record for each date. What I want is the total across the range of dates given.

Here's where I'm at...any pointers?

[vba]PARAMETERS lEmpID Long, dtFrom DateTime, dtTo DateTime;
SELECT TP.empID, Sum(DateDiff("n",[dtTimeIn],[dtTimeOut])/60) AS Hours
FROM tblTimePairs AS TP
GROUP BY TP.dtWork, TP.empID
HAVING (((TP.dtWork) Between [dtFrom] And [dtTo]) AND ((TP.empID)=[lEmpID]));
[/vba]