Query Half fixed

[Pharcyde]

I have a query running off a crosstab query. When openin in a from its fine, but if opening as a subform i get 'You can't use a pass-through query or a non-fixed-column crosstab query as a record source for a subform or subreport

I've sorted this by setting (fixing) the column headings. But its given me a new problem. The queries running off it produce a Type Mismatch error message.

Its probably easy I know, but i cant work it out !?

HELP