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 ....
---------3

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 can't really make this out, but it looks like you want a cross tab query.

Create the query and add the fields you want to show. It looks like 3 fields.

Then Select Query > Cross Tab Query.

Then select Date for Row Heading, Hour for Column Heading, Visitors as Value, and Group by Count.

That should do it.

Does that work for you?


mmcdonal

mmcdonal , i got it thanks a lot

SO that worked as you wanted, or did you come up with something else?

mmcdonal