J
John
I have two queries that contain the following data, one with employee code -
date worked - and sum of hours worked. The second query has the employee code
- date scheduled - and the schedule code (see example below). I am trying to
write a query that would return one line for the employee code with the
corresponding details of the schedule code and hours worked on the next line.
Query 1:
Emp Date Hours
xxx 08/17/08 9:30
xxy 08/17/08 10:15
xxx 08/18/08 8:15
xxy 08/18/08 12:00
xxx 08/19/08 8:30
xxy 08/19/08 10:00
Query 2:
Emp 08/17/08 08/18/08 08/19/08
xxy WS3 NS3 WS3
xxx NS3 WS3 WS3
I would like Query 3 (new) to return the following:
Emp 08/17/08 08/18/08 08/19/08
xxx NS3 WS3 WS3
xxx 9:30 8:15 8:30
xxy WS3 WS3 WS3
xxy 10:15 12:00 10:00
Any help would be greatly appreciated.
Thanks
John
date worked - and sum of hours worked. The second query has the employee code
- date scheduled - and the schedule code (see example below). I am trying to
write a query that would return one line for the employee code with the
corresponding details of the schedule code and hours worked on the next line.
Query 1:
Emp Date Hours
xxx 08/17/08 9:30
xxy 08/17/08 10:15
xxx 08/18/08 8:15
xxy 08/18/08 12:00
xxx 08/19/08 8:30
xxy 08/19/08 10:00
Query 2:
Emp 08/17/08 08/18/08 08/19/08
xxy WS3 NS3 WS3
xxx NS3 WS3 WS3
I would like Query 3 (new) to return the following:
Emp 08/17/08 08/18/08 08/19/08
xxx NS3 WS3 WS3
xxx 9:30 8:15 8:30
xxy WS3 WS3 WS3
xxy 10:15 12:00 10:00
Any help would be greatly appreciated.
Thanks
John