Crosstab Queries

[djclinton15]

Excuse me for possibly asking the dumbest question, but can a Crosstab query have a subquery Crosstab query within? I tried & received this error message: You can't use a pass through qeury or a non fixed-column crosstab query as a record source for a subform or subreport. (Before you bind a subquery or subform to a crosstab query, set the ColumnHeadnings property.)

Any advise/suggestions would be greatly appreciated! Thanks in advance!

[Bulzie]

Guess you can't if you get an error. What is it you are trying to display?

[ranman256]

Probably not a good idea.
you can create many select queries in a union query THEN make a Crosstab.