Crosstab query

[elena]

Hi, All
I have a table with following fields:

IssDate IssTime Tick Badge Locat Viol
6/18/07 15:30 102003 999 MAIN 141
6/19/07 16:30 102023 999 MAIN 151
6/22/07 17:30 102022 999 MAIN 146

Is it posible in the crosstab query show summary for the every day of the week
with actual date assign like "Sunday 6/17/07" and have as many columns as 7
for every day?
Please, help

How can i produce produce following result:

Badge Sunday Monday Tuesday Wednesday Thursday ......
6/17/07 6/18/07 6/19/07 6/20/07 6/21/07

999 0 1 1 0 0

 

[elena]

Hi, Chris2
Thank you so much, both queries work great,
I am using first one where output fields have WeekDay and Date "Sunday
06/17/07"
Is it possible to define the order how fields will be display like from
Sunday?

Thank you again for your help,
best regards

 

[Chris2]

Hi, Chris2
Thank you so much, both queries work great,

elena,

You are welcome.

Is it possible to define the order how fields will be display like from
Sunday?

If you use:

IN ("Sunday"
,"Monday"
,"Tuesday"
,"Wednesday"
,"Thursday"
,"Friday"
,"Saturday")

The weekday names will be in order.

If you are using dates, I do not know how to do it.


Sincerely,

Chris O.