M
mmk
Guest
Dear All,
i have a query result same as following List1, my boss want me to show it like this: please help.
(Hour)
Date/Hour 9:00 10:00 11:00....
(date)1 2 80 ....
2 14 98 ....
List1:
TimeInHour TimeInDate Visitor_NumOfSum
09 01 2
09 02 14
09 04 13
09 05 9
09 06 12
09 07 4
09 13 16
09 14 1
09 16 9
09 17 6
09 20 6
09 21 2
10 01 80
10 02 98
10 03 66
10 04 92
10 05 136
10 06 73
10 07 44
10 09 46
10 10 37
10 11 70
i have a query result same as following List1, my boss want me to show it like this: please help.
(Hour)
Date/Hour 9:00 10:00 11:00....
(date)1 2 80 ....
2 14 98 ....
List1:
TimeInHour TimeInDate Visitor_NumOfSum
09 01 2
09 02 14
09 04 13
09 05 9
09 06 12
09 07 4
09 13 16
09 14 1
09 16 9
09 17 6
09 20 6
09 21 2
10 01 80
10 02 98
10 03 66
10 04 92
10 05 136
10 06 73
10 07 44
10 09 46
10 10 37
10 11 70
Last edited:
