Dynamic report from crosstab query

[justice8965]

Hey all

I'm trying to generate a report based on 3 crosstab queries. Each query has a date range which is the same for each query (1/1/2010-1/31/2010 for ex), and a number of columns based on criteria chosen by the user. For example, if they choose "Zone 3" qry1 might have 4 columns, qry2 might have 2, and qry3 might have 3. Is it possible to create a dynamic report based on these queries, through VBA or otherwise? I have no idea where to begin here. Thank you for any help.

 

[llkhoutx]

Generate all possible columns in you crosstab queries. Then use unions queries to have all the queriies' respective results in one query, then sum the union query.