Cross Tab Query with Multiple Field Headers

[jkonline2]

Is it possible to use multiple fields for the column headers of a cross tab query while only having one row source? and if so how?

 

[DanChard]

I don't know a lot about cross-tab queries but if you give me some idea of your table layout and what you want to achieve I might be able to give you some SQL that will do the job...

 

[jkonline2]

I eventually managed it by creating 3 seperate cross tab queries and then putting them together in another query thanks for the offer of help any how