2-TABLES:
TABLE 1: Employees/Payroll
EmployeesPayrollID
Mnth/Year
Day
Date
Employees Name
HRS (Hours worked – Date)
TABLE 2: Projects/Tasks
ProjectsTasksID
EmployeesPayrollIID
Mnth/Yr
Day
Date
Project Name
HRS (Hours worked on Project – Date)
*Tables are joined by “EmployeesPayrollID”
Why can I NOT run a query showing me both the #-hours from the Employees/Payroll Table & from the Projects\Tasks Table of the same date?
I tried pulling “Mnth/Yr,” ”Day,” ”Date,”& “HRS” from the Eployees\Payroll Table -&- the “HRS” from the Projects\Tasks Table & selected, “Sum” under both HRS & in return I got no results. Can I get any help?