The final product is exactly what I'm asking for but I'm not sure how you got there... Could you explain a little further? I modded the original statement to include my actual field and table names....

strSQL = "SELECT LastName, FirstName, Sum(CDbl([ControlledHours])) * 24 AS [Tot Ctr], Sum(CDbl([UncontrolledHours])) * 24 AS [Tot Unctr] FROM [CS-RepTable] INNER JOIN [DAT-DayStatsTable] ON [CS-RepTable].IDNUM = [DAT-DayStatsTable].IDNUM WHERE ((([DAT-DayStatsTable].DATE) Between" & "#" & tbsWeek.Tabs(1).Tag & "# AND #" & tbsWeek.Tabs(6).Tag & "#)) GROUP BY LastName, FirstName"

Isn't this selecting Lastname, Firstname ControlledHours and UncontrolledHours from the [CS-RepTable]??

The actual data resides in the [DAT-DayStatsTable]. But it's still coming out correctly even if I change the data in the [DAT-DayStatsTable]. Am I missing something here?

Not that I'm not greatful for the help or anything, I just want to know how it works naturally =)


Eiredrake