getting the start time and finish time

M

mel

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
 
D

Duane Hookom

Nope. We might if we could see your database and read your specifications.
 
V

vvariety

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

Employee WorkTime
J.Doe 8hrs
 
Top