need help with cross tab query

[wilkob]

I know a lot has been written about above type of query but I think this problem has not been discussed before.

I want to show per customer YTD and LYTD turnover and profit figures.
I am now so far that via a crosstab query I am getting:

customer Turnover 2004 Turnover 2005

which is perfect, but I would also like to have the profit in the query. It seems that it is not possible to do this in a cross tab query. Does anybody have some solution to my problem????

 

[GabrielR]

Well what I usually end up doing in these Cases is just creating different crosstab queries and then creating a query that puts all the information from those Crosstab query in one, joining the fields using the rowheader, wich will be the common set of data in the query....

It works quite well here in a database that I use very often.