Trying this query from 2-Tables

[djclntn]

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?

[orange]

Some help:

Day, Date are reserved words in Access.
Here's a full list
http://allenbrowne.com/AppIssueBadWord.html

It is recommended that you do NOT use special characters or embedded spaces in your field and object names.

Show us the query you were trying to run.

[djclntn]

I showed my Query above:
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.

Ought I change my DAY & DATE Field Names?

[orange]

Can you post the sql for your query?

eg

SELECT Reservations.[Room Type], Avg(DateDiff("d",[Arrival Date],[Departure Date])) AS [Avg Length of Stay], Avg(Reservations.[No of Guests]) AS [Avg # of Visitors], Avg(Reservations.[Daily Rate]) AS [Daily Rate]
FROM Reservations
GROUP BY Reservations.[Room Type]
ORDER BY Reservations.[Room Type];

[djclntn]

Gladly, I went ahead & changed my DAY & DATE Field Names

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;

[djclntn]

I'm not sure if I sent you what you were asking?

[orange]

I have mocked up a query using my own tables and data to approximate your situation.

The query and the table structures are shown in djclntn0.jpg
The query result and the data in the tables is shown in djclntn1.jpg