how to query this???

[Malix]

Hi everyone!
I hope I'm posting this in the right place.... anyway, here's the problem:

i have a database like this:

DAY__________WEBSITE_______VISITS_______CLICKS
12/2010_________A____________2000_________3000
12/2010_________B____________1500_________3500
12/2010_________C____________1800_________2000
13/2010_________A____________2100_________3100
13/2010_________B____________1600_________3600
13/2010_________C____________1900_________2100

and I want to create 2 different pivot tables:

1) check performances of every website (I can do this one)

 Filter: website A
DAY__________WEBSITE_______VISITS_______CLICKS
12/2010_________A____________2000_________3000
13/2010_________A____________1500_________3500

2) compare one performance of the different websites

 Filter: VISITS
DAY__________WEBSITE A____WEBSITE B____WEBSITE C
12/2010_________2000__________1500_________1800
13/2010_________2100__________1600_________1900

I really don't know where to start to get those kind of informations without creating a new database

any suggestion???

[pbaldy]

Play with the crosstab query wizard for the second one.

[Malix]

I made it, thank you!

but... is it possible to use it like a Pivot?
I mean, how can I easily switch between showing visits and clicks?
do I have to create a crosstable for each item? (of course in my database I've a bit more items than two ^^)