I am running a query that uses multiple crosstab queries as source. This query is used to populate a report so I need fixed column headers to avoid the occurance of missing fields in the crosstabs. When I do this I get the error
"Cannot use the crosstab of a non-fixed column as a subquery. (Error 3637)"

Any help is appreciated.