Please help (1 Viewer)

basehumax

Registered User.
Local time
Today, 05:37
Joined
May 14, 2018
Messages
12
: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;
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:37
Joined
May 7, 2009
Messages
19,169
copy and paste the sql to notepad. ctrl-h, replace Employee with tblEmployee. copy and paste back to access.
 

basehumax

Registered User.
Local time
Today, 05:37
Joined
May 14, 2018
Messages
12
copy and paste the sql to notepad. ctrl-h, replace Employee with tblEmployee. copy and paste back to access.

Thanks

i try didn't work maybe i am making mistake can you please help me

Thanks
 

Users who are viewing this thread

Top Bottom