:banghead:
i have changed the Employees table of the query to tblEmployees and i cannot edit the query as it only shows SQL View here is the sql code.
Please help i couldn't figure out hours and hours
Thank you in advance.
SELECT Employees.EmployeeID, LastName,[FirstName] & " " & [LastName] AS Employee,
WeekStart(1,WorkDate) AS WeekStarting
FROM Employees INNER JOIN TimeLog
ON Employees.EmployeeID = TimeLog.EmployeeID
UNION SELECT Employees.EmployeeID, LastName,[FirstName] & " " & [LastName],
WeekStart(1,WorkDate)
FROM Employees INNER JOIN EmployeeUnworkedTimes
ON Employees.EmployeeID = EmployeeUnworkedTimes.EmployeeID;
i have changed the Employees table of the query to tblEmployees and i cannot edit the query as it only shows SQL View here is the sql code.
Please help i couldn't figure out hours and hours
Thank you in advance.
SELECT Employees.EmployeeID, LastName,[FirstName] & " " & [LastName] AS Employee,
WeekStart(1,WorkDate) AS WeekStarting
FROM Employees INNER JOIN TimeLog
ON Employees.EmployeeID = TimeLog.EmployeeID
UNION SELECT Employees.EmployeeID, LastName,[FirstName] & " " & [LastName],
WeekStart(1,WorkDate)
FROM Employees INNER JOIN EmployeeUnworkedTimes
ON Employees.EmployeeID = EmployeeUnworkedTimes.EmployeeID;