Double column row on graph

[skizzly]

Hi experts,

See attached database. I am trying to achieve a query that produces two column heads on a graph. i have tried a crosstab query but it is limited to a single column header.... is this possible?

The first row would produce a list dates (dynamic in range) then above that the list of services (service1 ...) then a count of each type of thing that services does (a1...)

yaxis

5
4 a1
3 a3 a1 a2 a3
2 a1 a3 a1 a2 a3 a2 a3
1 a1 a3 a1 a2 a3 a2 a3
0 a1 a2 a3 a1 a2 a3 a1 a2 a3

xaxis
0 service 1 service 2 service 3
date1 date2 date3

Any help with how i can do this will be gratefully received.

:banghead:

 

[CJ_London]

use two (or more) crosstabs and then another query to bring them together

 

[skizzly]

hey CJ thanks for reply...

the thing is how would the query be designed to produce the results.. not good enough to write sql without the help of you experts...

have attached a picture to show what i am trying to achieve... thanks again