Combine Crosstab Query

[carter1367]

Hello. I have two crosstab queries. One shows the clients and a count of Types, and the other shows the clients and a count of products. Both queries shows me the right information, but I would like to combine them so it looks similar to the attachment.

I have looked at the microsoft help, but I don't need anything to do with dates.

Any help would be much appreciated

Thanks

James

 

[Trevor G]

You may have several options here but my first would be to create another query that uses the 2 crosstabs relate them against the customerID and then drag the fields in and you should get your solution.

If this fails then think about using some make table queries and continue on the lines I have suggested, then use a MACRO to run them for you.