G
Guest
Hi, All
I have table with a few fields of user's activities, it looks like foloowing:
IsDate IsTime Id Unit Activity Code
5/1/07 8:00 614 01 SignOn SO
5/1/07 12:00 614 01 Breakstart BB
5/1/07 12:30 614 01 Breakend BE
5/1/07 14:30 614 01 Breakstart BB
5/1/07 14:45 614 01 Breakend BE
5/1/07 17:30 614 01 Breakstart BB
5/1/07 17:40 614 01 Breakend BE
5/1/07 18:00 614 01 Statustart SB
5/1/07 18:30 614 01 Statusend SE
5/1/07 19:30 614 01 EndShift SF
5/1/07 19:30 614 01 Download DL
I need result looking as crosstab query:
ID Unit SignOn BB1 BE1 BB2 BE2 BB3 BE3 SS1 SE1
SF DL
614 01 8:00 12:00 12:30 14:30 14:45 17:30 17:40 18:00 18:30 19:30
19:30
It shows the time when user sign on, takes break(up to 3 breaks), then
status begin(some other activities) and status ends, shows end shift and
download time, and group by Id and Unit.
Please, help
I have table with a few fields of user's activities, it looks like foloowing:
IsDate IsTime Id Unit Activity Code
5/1/07 8:00 614 01 SignOn SO
5/1/07 12:00 614 01 Breakstart BB
5/1/07 12:30 614 01 Breakend BE
5/1/07 14:30 614 01 Breakstart BB
5/1/07 14:45 614 01 Breakend BE
5/1/07 17:30 614 01 Breakstart BB
5/1/07 17:40 614 01 Breakend BE
5/1/07 18:00 614 01 Statustart SB
5/1/07 18:30 614 01 Statusend SE
5/1/07 19:30 614 01 EndShift SF
5/1/07 19:30 614 01 Download DL
I need result looking as crosstab query:
ID Unit SignOn BB1 BE1 BB2 BE2 BB3 BE3 SS1 SE1
SF DL
614 01 8:00 12:00 12:30 14:30 14:45 17:30 17:40 18:00 18:30 19:30
19:30
It shows the time when user sign on, takes break(up to 3 breaks), then
status begin(some other activities) and status ends, shows end shift and
download time, and group by Id and Unit.
Please, help