Of course I can run 2-seperate queries displaying the total sum of hours (per date) from the Employees/Payroll Table & another query from the ProjectsTasks Table. Except, I want to know if/how I can view the sum of hours from the Employee/Payroll Table & from the ProjectsTasks Table in a query

Eg.
DATE SumOfEmployes/PayrollHRS SumOfProjectsTasksHRS
11/13/2011 6 9.5

Here's the SQL I tried:
SELECT [Daily Tasks].[MNTH/YR], [Daily Tasks].WDAY, [Daily Tasks].TDATE, Sum([Daily Tasks].HRS) AS SumOfHRS1, Sum([Employees/Payroll].HRS) AS SumOfHRS
FROM [Daily Tasks] INNER JOIN [Employees/Payroll] ON [Daily Tasks].DailyTaskID = [Employees/Payroll].DailyTaskID
GROUP BY [Daily Tasks].[MNTH/YR], [Daily Tasks].WDAY, [Daily Tasks].TDATE;