getting the start time and finish time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey i am trying to get the start time and finish time by the column
[worktime], and the employee id. Do anyone know how to get the start time
into a new column and finish time into another by per employee.

cheers
 
if worktime is a calculated field sounds like you need to do a crosstab
query producing

Employee WorkTime
J.Doe 8hrs
 
Back
Top