Play with the crosstab query wizard and see if you get what you're after. By the way, you don't need a field for the day of the week. It can always be derived from the date field with built-in functions. And the date field should not be named "date", as it is a reserved word:
I have played with the crosstab query wizard, the results that i am getting are close but it still can't get the results to display as one row, i.e if there is more than one site for the week they are displayed on different rows. I have played with the grouping options but am still unable to get the results i'm after.