Cross tab query with 2 column headers (1 Viewer)

[adi32]

I have an access 2000 database and i want to make a cross tab query with 2 column headers but access doesnt allow that


I decide to make the inverted cross tab query and its ok
but now i want to use this in a report but inverted

ex
product type client1 client2 client3
a 1
b 2
c 3


product a product b product c
type 1 type 2 type 3
client1
client2
client3

 

[grnzbra]

Are you trying to achieve something like three crosstabs stacked one above the other?

 

[adi32]

i want to make a crosstab query with 3 column headers and 1 column row
but access allow the creation of crosstab query with only 1 column headers and 3 column row

 

[grnzbra]

The three column headers. Are they similar to three groupings in a report? What I'm visualizing is creating three crosstab queries and then use them to drive a union query.